Forum Discussion

pablofigueira's avatar
pablofigueira
Frequent Visitor
3 years ago
Solved

Not SELECTEDVALUES

Hi Everyone,   I´m having a problem with SELECTEDVALUE. I want to get a sum (anycolumn) for all objects in slicer that is not selected.   (  ) Option A (  ) Option B (X) Option C   Here I wan...
  • johnt75's avatar
    johnt75
    3 years ago

    You can use

    Unselected items =
CALCULATE (
    [Measure],
    EXCEPT ( ALL ( 'Table'[Column] ), VALUES ( 'Table'[Column] ) )
)
pablofigueira's avatar
pablofigueira
Frequent Visitor
3 years ago

Looks like perfect. Tks