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.
daxTotal 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:
daxHigh 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