Forum Discussion
Measure returns 100% after slicing data
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. 🤔
Super UserWhen 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).