Power BI Exercises

Revenue of an average shop

Advanced DAX · Intermediate · Chapter 9 of 10. Variables, ranking, iterators and dynamic labels.

The request, from Owen Price, Founder, Copperbean Coffee: "What does an average shop sell in each category? I want a benchmark for the managers." A measure named Avg Shop Revenue.

AVERAGEX(VALUES(Store[Store]), [Total Revenue]) computes the revenue of each shop, then averages them. That is different from AVERAGE, which would average individual order lines.

Task: Create Avg Shop Revenue = AVERAGEX(VALUES(Store[Store]), [Total Revenue]).

Practice data: Copperbean Coffee, a fictional chain of coffee shops. The model has the Orders, Drink and Store tables.

DAX functions used: AVERAGEX, VALUES.

How it works: the exercise opens a practice copy of the Power BI report editor in your browser. Do the task, press Check, and your result is compared with the expected answer in seconds. Hints are there if you get stuck.

Keep practicing