topic Not SELECTEDVALUES in DAX Commands and Tips

Not SELECTEDVALUES

pablofigueira — Thu, 29 Sep 2022 13:29:25 GMT

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

Re: Not SELECTEDVALUES

johnt75 — Thu, 29 Sep 2022 13:34:29 GMT

You can use

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

Re: Not SELECTEDVALUES

pablofigueira — Thu, 29 Sep 2022 14:12:13 GMT

Looks like perfect. Tks

Re: Not SELECTEDVALUES

pablofigueira — Thu, 29 Sep 2022 20:22:23 GMT

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,

Re: Not SELECTEDVALUES

johnt75 — Fri, 30 Sep 2022 08:54:27 GMT

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.