Recap - Store Share in 2025

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

Challenge

Mia's board asks which shops carried 2025. Write Share of 2025: a store's Revenue as a share of the revenue of all stores. The table is filtered to 2025; it is checked for each store and the total.

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 ShownRecap - 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