Recap - Profit Without Columns

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

Challenge

Mia wants profit by category, and this model has no cost column. Write Profit: for each order line, the amount paid minus the quantity times its product's unit cost, added up. It is checked for each category.

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 DAX Recap - 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 RANKXRecap - Profit Without Columns