THE CALCULATE FUNCTION exercises

This page lists the 12 exercises about The CALCULATE function in Power Pivot on our website:

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the CALCULATE and KEEPFILTERS functions in Power Pivot to alter the behaviour of context filters in Excel pivot tables.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the DAX Calculate function to add filters to measures in Power BI Desktop.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the DAX CALCULATE function to replace context filters.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the REMOVEFILTERS function in DAX to modify the filter context of measures in Power Pivot for Excel.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the ALL or REMOVEFILTERS functions in Power Pivot to calculate percentages of group totals in a pivot table.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the ALLEXCEPT function to remove multiple filters in a DAX measure in Power Pivot for Excel.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the ALLSELECTED function in Power Pivot to write DAX measures more efficiently.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the CALCULATE function in DAX measures to add filters to expressions.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the CROSSFILTER function in DAX measures to control the direction of relationships in a Power Pivot data model.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the DAX CALCULATE function to replace existing context filters in Power Pivot.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the KEEPFILTERS function in DAX to modify the way context filters behave in pivot charts.

Show this exercise

Software:	Power Pivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Use the CALCULATE function in DAX to apply filters to measures in Excel Power Pivot.

Show this exercise

You can search our full list of Power Pivot exercises here. Or why not learn to do them the right way on one of our Power Pivot training courses? You can attend our online training classes wherever you are in the world!

None of the exercises or supporting files may be copied in any form or used commercially without the prior written permission of Wise Owl (although you're welcome to use them for testing your own knowledge).

This page has 0 threads

Add a new post