THE CALCULATE FUNCTION exercises

This page lists the 16 exercises about The CALCULATE function in DAX on our website:

Software:	DAX
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Remove the filter context using the CALCULATE function in a measure.

Show this exercise

Software:	DAX
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the CALCULATE and KEEPFILTERS functions in DAX to alter the behaviour of context filters in Power BI visuals.

Show this exercise

Software:	DAX
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:	DAX
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the DAX CALCULATE function to replace context filters.

Show this exercise

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

Show this exercise

Software:	DAX
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Calculate the ratio between normal and multi-legged animals, using variables, CALCULATE and VALUES.

Show this exercise

Software:	DAX
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Show ratios for a table of premier league results, using the CALCULATE function.

Show this exercise

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

Show this exercise

Software:	DAX
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the ALLSELECTED function to modify the way filters work.

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

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

Show this exercise

Software:	DAX
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the REMOVEFILTERS function to alter the way context filters behave in DAX measures.

Show this exercise

Software:	DAX
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Sort Bake-Off viewing figures using the RANKX function.

Show this exercise

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

Show this exercise

You can search our full list of Power BI exercises here. Or why not learn to do them the right way on one of our Power BI 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