Forum Discussion
Solved
Selection
I have a dashboard where the end-user can select one of several options to filter a table. I also have a label that shows what the current selection is. I need a way to make the label say ALL when no...
So you can do something like:
Label Measure = IF(HASONEVALUE('Table'[Column]),MAX('Table'[Column),"All")For a really fancy version of this: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer-Title-Measure-Ever/td-p/429587
if you only needed to know if one was selected HasOneValue() would work, but if a user might have 2 selected, then there wouldn't be a away to distinguish between that and all selected (or none selected, which is the same as all)
This should work though.
Measure =
VAR TotalCount =
CALCULATE(
DISTINCTCOUNT(Database[Column1]),
REMOVEFILTERS(Database[Column1])
)
VAR SelectedCount =
CALCULATE(
DISTINCTCOUNT(Database[Column1]),
ALLSELECTED(Database[Column1])
)
RETURN
IF(
SelectedCount = TotalCount,
"ALL",
"Whatever you want to return otherwise"
)
It simply counts how many are in the list, then how many are selected. If they are the same, it returns "ALL" in the text.