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

Popular posts from this blog

Difference between DISTINCT and VALUES in DAX