Forum Discussion

lmundia's avatar
lmundia
Frequent Visitor
10 years ago
Solved

DAX Function - Help

I have a DAX function IF(AND that I am expecting to return a true value but it's returning false and I am not sure what I am doing wrong. When there are multiple selections I am expecting it to return "Multiple Selections" but it's returning the department names rather.

Selection Results = IF(AND(Departments[Department]= "Finance", Departments[Department]= "Human Resources"), "Multiple Selections", Departments[Department])

 

 

Thank you in advance

  • Sean's avatar
    Sean
    10 years ago

    lmundia Try this Measure...

     

    Selection Results = IF ( HASONEVALUE (Departments[Department]), VALUES(Departments[Department]), "Multiple Selections")

     

1 Reply

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    lmundia Try this Measure...

     

    Selection Results = IF ( HASONEVALUE (Departments[Department]), VALUES(Departments[Department]), "Multiple Selections")