Posts

Showing posts with the label EXCEPT

Set functions in DAX: UNION, INTERSECT and EXCEPT

https://www.sqlbi.com/articles/set-functions-in-dax-union-intersect-and-except/  
Post a Comment
Read more

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)
Post a Comment
Read more