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

Anonymous , In DAX the && or || operator will only work to separate two complete conditions with its operations. You can't use "and" to separate numbers or make smaller conditions. You always have to write the complete statatement for each one. You can think them as AND() or OR() functions. They need the complete statement inside the function.

Hope this make sense