Recap - Sales by Price Band

Part of the DAX with CALCULATE section of Coddy's Power BI journey. Lesson 24 of 24.

Challenge

Do the expensive products pay? Add a column Price Band to Products ("Premium" for a unit price of 10 or more, "Standard" for 4 or more, "Budget" for the rest), then build a column chart of Revenue by Price Band.

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATE A Filter Replaces a Filter Several Filters at Once Keeping Filters Recap - Member Drink Sales

4DAX You Can Read

Variables with VAR Choosing with SWITCH SWITCH(TRUE()) for Ranges One Value or Many Rows or the Total Checking Copilot's DAXRecap - Sales by Price Band

2Removing Filters

ALL Removes Filters Percent of Total Removing One Filter Keep One Filter: ALLEXCEPT Share of What Is Shown Recap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by Row AVERAGEX and MAXX FILTER Picks Rows Measures Inside Iterators Ranking with RANKX Recap - Profit Without Columns