PowerPivot exercises on THE CALCULATE FUNCTION

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

Software: PowerPivot
Version: Excel 2016 and later
Topic: The CALCULATE function
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the CALCULATE function to show percentages of row and column totals in a pivot table.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: The CALCULATE function
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use the CALCULATE function to pick out only transactions whose price is a given amount.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: The CALCULATE function
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Use ALL and CALCULATE to get proportions of totals for regions.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: The CALCULATE function
Level: Relatively easy
Course: PowerPivot / Excel Power BI
Exercise: Divide sales by 4 legs and other for a measure, using the FILTER function.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use the CALCULATE function to show total sales for Northern powerhouse shopping centres.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use the RANKX function to order total sales over species.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use FILTER and ALL to show sales as a proportion of one region's total.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Create measure using CALCULATE and ALL to get ratios against total.

Go to exercise ...

Software: PowerPivot
Version: Excel 2016 and later
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Create a ratio of sales between two different habitats, using the CALCULATE and SUMX functions.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Exclude a month from totals using the VALUES function to retain context.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: The CALCULATE function
Level: Average difficulty
Course: PowerPivot / Excel Power BI
Exercise: Use CALCULATE to work out the ratio of total sales to sales for a specific type of animal.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: The CALCULATE function
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Use AVERAGEX to find average ratios, then CALCULATE to avoid divide-by-zero errors.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: The CALCULATE function
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Filter calculated sums to compare two stores' sales figures.

Go to exercise ...

Software: PowerPivot
Version: Excel 2010 and later
Topic: The CALCULATE function
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Create a calculated column using EARLIER to show previous joiner count.

Go to exercise ...

Software: PowerPivot
Version: Excel 2013 and later
Topic: The CALCULATE function
Level: Harder than average
Course: PowerPivot / Excel Power BI
Exercise: Omitting a particular shopping centre from totals, using the VALUES function.

Go to exercise ...

You can search our full list of Power BI exercises here, or why not have a look at our other Power BI training resources?

This page has 0 threads Add post