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,

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a measure like

if( calculate(distinctcount(Table[number]), table[number] in {1,2})>=2,"1 and 2 are found", blank())

Anonymous's avatar
Anonymous
Not applicable
5 years ago

No, that did not solve it. selecting anything will now give the "1 and 2 are found" message.

 

It can't be a calculate type measure, as the list to choose from might also be text. 

So instead of Numbers 1,2,3,4,5,6

Let's assume it's A,B,C,D,E and when specifically A and B is chosen, I want "A and B are chosen".