Recap - The Numbers Mia Wants

Part of the Power BI Basics section of Coddy's Power BI journey. Lesson 14 of 28.

Challenge

Mia asks: on average, how many items does each customer buy at each shop? Write Units per Customer: the items sold divided by the number of different customers, safely. It is checked for each store.

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in Power BI Basics

1Meet Power BI

What Power BI Is Tables, Rows and Columns Your First Chart Sum, Count and Average Filters and Slicers Recap - Mia's First Report

4Calculated Columns

Columns vs Measures IF in a Column Text Columns Looking Up with RELATED Columns Feed Measures Profit and Margin When to Use Which Recap - Profit by Category

2Your First Measures

What a Measure Is Counting Rows Average, Min and Max Counting Distinct Things Measures Can Do Math Safe Division with DIVIDE Measures Use Other MeasuresRecap - The Numbers Mia Wants

3One Measure, Many Answers

Same Measure, Every Bar The Total Row Slicers Change the Answer Two Fields on Rows Filters Follow Relationships Recap - The Store Report