GoSkills
Back to lesson
Question
1
of
3
1. How many ALL() functions can you include in the filters of your CALCULATE() measure?
Up to five
As many as you like
Only one
Don’t know
2. In the example measure below, how do we add a function to remove filters for locations? =CALCULATE([Sales $],ALL('Calendar'[Year]))
=CALCULATE([Sales $],ALL('Calendar'[Year] && (Locations))
=CALCULATE([Sales $],ALL('Calendar'[Year]),ALL(Locations))
=CALCULATE([Sales $],ALL('Calendar'[Year],(Locations))
Don’t know
3. The following chart was created with Sales $ in the values and End of Month on the axis. You want to retain the total of $2.7m of Sales $ in a card when any data point is clicked. Which formula will do that for you?
=CALCULATE([Sales $],ALL(Calendar[Month]))
=CALCULATE([Sales $],ALL(Calendar))
=CALCULATE([Sales $],ALL(Sales))
Don’t know
Quiz progress
Previous
question
Next
question
Submit
answers
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement