Menu
CoddyTech
Start learning

Meet CALCULATE

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

CALCULATE runs an expression under filters you add.

Coffee Revenue = CALCULATE([Revenue], Products[Category] = "Coffee")

First the expression, then the filters. Each bar keeps its own filters and gets yours too.

Text in double quotes, numbers without: Dates[Year] = 2025. Any comparison works: Sales[Quantity] >= 3.

challenge icon

Challenge

How much coffee does each shop sell? Write Coffee Revenue: Revenue with the filter Products[Category] = "Coffee". It is checked for each store.

bugsy Main icon

Start this challenge with Coddy's AI tutor

What is Bugsy?

All lessons in DAX with CALCULATE

1Changing the Filters

Meet CALCULATEA Filter Replaces a FilterSeveral Filters at OnceKeeping FiltersRecap - Member Drink Sales

4DAX You Can Read

Variables with VARChoosing with SWITCHSWITCH(TRUE()) for RangesOne Value or ManyRows or the TotalChecking Copilot's DAXRecap - Sales by Price Band

2Removing Filters

ALL Removes FiltersPercent of TotalRemoving One FilterKeep One Filter: ALLEXCEPTShare of What Is ShownRecap - Store Share in 2025

3Row by Row in a Measure

SUMX Works Row by RowAVERAGEX and MAXXFILTER Picks RowsMeasures Inside IteratorsRanking with RANKXRecap - Profit Without Columns