Checking Copilot's DAX

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

A measure can run without an error and still answer a different question.

Check which filters it removes, one row you know, and the total.

Store Share = DIVIDE([Revenue], CALCULATE([Revenue], ALL(Products)))

By store this is 1, or 100%, everywhere: it removes the wrong table's filters.

Challenge

Copilot wrote Store Share for Mia, and every store shows 1, which is 100%. Fix it so each store shows its share of all stores. It is checked for each store and the total.

Start this challenge with Coddy's AI tutor

What is Bugsy?

Test yourself

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

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