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] ) )
)
johnt75's avatar
johnt75
Super User
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

Hi...

 

Can I make this?

 

CALCULATE (
[Measure],
EXCEPT ( ALL ( 'Table'[Column] ), VALUES ( 'Table'[Column] ) ),
EXCEPT ( ALL ( 'Table'[Column] ), VALUES ( 'Table'[Column] ) ),

EXCEPT ( ALL ( 'Table'[Column] ), VALUES ( 'Table'[Column] ) )
)

 

Since the columns inside lines are different,

 

 

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    Technically you could, but I would not recommend it. You would need to have a very clear understanding of the model, the data, and how it all interacts with each other.

    Different implementations might be better if more than one column is involved but, again, you would need to have a very clear understanding of the model and what you are trying to achieve - e.g. should the filters act as AND or OR.