Forum Discussion
Measure returns 100% after slicing data
Super UserALLSELECTED includes the filter on FFF. If you don't want that, then you need a denominator that includes all FFF. I don't know if this is exactly what you want but you can try e.g.
var denominator =
CALCULATE( SUM( 'Tmp'[Amt] ),
ALL ( 'Tmp'[FFF] ),
'Tmp'[YYYY_MM] = max_yyyy_mm
)
Wow. That did the trick. Thank you so much AlexisOlson 🤗 . But I still can't quite wrap my mind around the logic. If I want the selection in FFF Slicer to affect Line-chart values, shouldn't I use ALLSELECTED() so that it'd consider ALL the datapoints that are selected using different slicers on the page ? And I get that the measure you pasted does work, however, shouldn't ALL() in there, enforce selection of ALL the categories that are available in FFF column. 🤔
- AlexisOlson
When you use ALL in a measure, it does not change your slicer selections on the page but does modify them when computing the value it returns. In particular, putting ALL in a measure does not prevent the slicer from filtering what program types display in a visual, it only affects the values for the things that remain displayed after filtering. The visual still only displays the value you've selected with your slicer but the measure computes the percentage for that particular value over not just that particular value but over the ALL of the values (by removing that slicer filter for the calculation).