THE CALCULATE FUNCTION exercises

This page lists the 15 exercises about The CALCULATE function in PowerPivot on our website:

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Divide sales by 4 legs and other for a measure, using the FILTER function.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use ALL and CALCULATE to get proportions of totals for regions.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the CALCULATE function to pick out only transactions whose price is a given amount.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Relatively easy
Exercise:	Use the CALCULATE function to show percentages of row and column totals in a pivot table.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Create a ratio of sales between two different habitats, using the CALCULATE and SUMX functions.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Create measure using CALCULATE and ALL to get ratios against total.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Exclude a month from totals using the VALUES function to retain context.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use CALCULATE to work out the ratio of total sales to sales for a specific type of animal.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use FILTER and ALL to show sales as a proportion of one region's total.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the CALCULATE function to show total sales for Northern powerhouse shopping centres.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Average difficulty
Exercise:	Use the RANKX function to order total sales over species.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Create a calculated column using EARLIER to show previous joiner count.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Filter calculated sums to compare two stores' sales figures.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Omitting a particular shopping centre from totals, using the VALUES function.

Show this exercise

Software:	PowerPivot
Topic:	The CALCULATE function
Level:	Harder than average
Exercise:	Use AVERAGEX to find average ratios, then CALCULATE to avoid divide-by-zero errors.

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