Not SELECTEDVALUES

[pablofigueira]

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 want to get the sum of Option A and  Option B.

I tried everything but I didn´t get it.

Any help, please?

Tks

Pablo

[pablofigueira]

Looks like perfect. Tks

[johnt75 · Accepted solution]

You can use

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

[pablofigueira]

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]

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.