Forum Discussion
Anonymous
6 years agoNot applicable
Help with Return IF function within a measure calculation
Hello Experts, I am trying to complete a measure calculation, however, facing issue with below error - "DAX comparison operations do not support comparing values of type True/False with values ...
AlB
Community Champion
6 years agoHi Anonymous
ISFILTERED('Table1'[Resource_Type]) yieds a boolean (TRUE/FALSE) value and you are comparing it to "Employee", which is text. That seems to be the cause for the error. IF it is a measure as you said, you probably need something like this instead:
SELECTEDVALUE('Table1'[Resource_Type]) = "Employee"
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers
Anonymous
6 years agoNot applicable
Thanks. Worked it well.