ScenarioINTERMEDIATEDifficulty: INTERMEDIATEFilter context~8 min

Why does this measure ignore the slicer?

A user reports that this measure shows the same value no matter what they select in the Region slicer.

dax
Total Sales UK =
CALCULATE (
    SUM ( Sales[Amount] ),
    Sales[Country] = "UK"
)

Wait — that one is expected to be fixed to the UK. Here is the actual problem measure:

dax
High Value Sales =
CALCULATE (
    SUM ( Sales[Amount] ),
    FILTER ( ALL ( Sales ), Sales[Amount] > 1000 )
)

Why does this measure ignore the Region slicer, and how would you fix it?

Go deeper on this

Analytics Systems

Power BI Inventory Control Tower

An inventory dashboard built around the four decisions a stock controller makes each week, with a semantic model that stays fast on 40 million rows.

IntermediateDifficulty: Intermediate~16h buildPower BI · DAX · SQL
Video