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 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

  • johnt75's avatar
    johnt75
    3 years ago

    You can use

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

4 Replies

  • 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.