Get Selected Items and Not Selected Items from Slicer
-- Get the colors selected in the slicer
VAR SelectedColors = CALCULATETABLE( VALUES(Product[Color], ALLSELECTED())
-- Get All Colors
VAR AllColors = ALL(Product[Color])
-- Get the colors not selected in the slicer
VAR NotSelectedColors = EXCEPT(AllColors, SelectedColors)
Comments
Post a Comment