Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
545 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
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. |
Software: | PowerPivot |
Topic: | The CALCULATE function |
Level: | Relatively easy |
Exercise: | Use ALL and CALCULATE to get proportions of totals for regions. |
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. |
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. |
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. |
Software: | PowerPivot |
Topic: | The CALCULATE function |
Level: | Average difficulty |
Exercise: | Create measure using CALCULATE and ALL to get ratios against total. |
Software: | PowerPivot |
Topic: | The CALCULATE function |
Level: | Average difficulty |
Exercise: | Exclude a month from totals using the VALUES function to retain context. |
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. |
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. |
Software: | PowerPivot |
Topic: | The CALCULATE function |
Level: | Average difficulty |
Exercise: | Use the CALCULATE function to show total sales for Northern powerhouse shopping centres. |
Software: | PowerPivot |
Topic: | The CALCULATE function |
Level: | Average difficulty |
Exercise: | Use the RANKX function to order total sales over species. |
Software: | PowerPivot |
Topic: | The CALCULATE function |
Level: | Harder than average |
Exercise: | Create a calculated column using EARLIER to show previous joiner count. |
Software: | PowerPivot |
Topic: | The CALCULATE function |
Level: | Harder than average |
Exercise: | Filter calculated sums to compare two stores' sales figures. |
Software: | PowerPivot |
Topic: | The CALCULATE function |
Level: | Harder than average |
Exercise: | Omitting a particular shopping centre from totals, using the VALUES function. |
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. |
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!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.