Share of What Is Shown

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

With a visual filter on, a share built with ALL still divides by everything.

ALLSELECTED removes the row's filter and keeps the visual's and the page's filters.

Share Shown = DIVIDE([Revenue], CALCULATE([Revenue], ALLSELECTED(Stores)))

The rows the visual shows add up to 100%.

Challenge

The table is filtered to Portugal and Spain. Write Share Shown: a store's Revenue as a share of the stores shown, so the rows add up to 100%. It is checked for each store.

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 Total Checking Copilot's DAX Recap - Sales by Price Band

2Removing Filters

ALL Removes Filters Percent of Total Removing One Filter Keep One Filter: ALLEXCEPTShare 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