Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX multiple selectedvalue slicer

Hi,   Couldn't find a previous post for this.   Say we have a table called Number   When both 1 and 2 are selected in slicer, I want the text to read "1 and 2 are found". Why is the foll...
Need Help
  • ibarrau's avatar
    ibarrau
    5 years ago

    Hi. The problem is that the 1 is not evaluated in that statement. It's only evaluating the 2. That's why it works with the two.

    Try adding the condition for both:

    Measure = 
IF ( 
    1 IN VALUES('Table'[Column1]) 
    && 2 IN VALUES('Table'[Column1])
    , "1 and 2 selected"
    , "False statement" 
)

    Hope this helps,

ibarrau's avatar
ibarrau
Super User
5 years ago

Hi. The problem is that the 1 is not evaluated in that statement. It's only evaluating the 2. That's why it works with the two.

Try adding the condition for both:

Measure = 
IF ( 
    1 IN VALUES('Table'[Column1]) 
    && 2 IN VALUES('Table'[Column1])
    , "1 and 2 selected"
    , "False statement" 
)

Hope this helps,