Back to lesson
1. The ALL() function can accept the following:
Either a table or a column
2. What does the ALL function do?
It overrides filters in the filter context with different values
It removes filters from the filter context
It adds filters to the filter context
3. If Sales $ is the sum of sales, what value will the following formula return? =CALCULATE([Sales $],ALL(Categories))
The total sales for all categories
The total sales for each category
The total sales except for a specific category
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement