When would you most commonly use the ALL() function in Power Pivot?

Select an answer:

• when you need values that are measured by the filters you set up in the pivot table layout

• when you want the filters applied to rows or columns to display in a pivot table layout

• when you want to quickly add a filter to all the rows or columns in a pivot table layout

• when you need unfiltered values that you do not want skewed by the pivot table layout