DAX Function - Help

[lmundia]

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 · Accepted solution]

@lmundia Try this Measure...

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