Menu
CoddyTech
Start learning

Filters Follow Relationships

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

Sales and Products are linked by a relationship on ProductID. A filter on Products flows to the sales of those products.

Filters flow from the lookup tables to Sales, not back: a store filter does not filter Products.

COUNTROWS(Products) counts the whole menu in every store row; DISTINCTCOUNT(Sales[ProductID]) counts what the store sold.

challenge icon

Challenge

How much of the menu does each shop really sell? Write Products Bought: how many different products appear in the sales. It is checked for each store.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?
quiz iconTest yourself

This lesson includes a short quiz. Start the lesson to answer it and track your progress.

All lessons in Power BI Basics

1Meet Power BI

What Power BI IsTables, Rows and ColumnsYour First ChartSum, Count and AverageFilters and SlicersRecap - Mia's First Report

4Calculated Columns

Columns vs MeasuresIF in a ColumnText ColumnsLooking Up with RELATEDColumns Feed MeasuresProfit and MarginWhen to Use WhichRecap - Profit by Category

2Your First Measures

What a Measure IsCounting RowsAverage, Min and MaxCounting Distinct ThingsMeasures Can Do MathSafe Division with DIVIDEMeasures Use Other MeasuresRecap - The Numbers Mia Wants

3One Measure, Many Answers

Same Measure, Every BarThe Total RowSlicers Change the AnswerTwo Fields on RowsFilters Follow RelationshipsRecap - The Store Report