Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
General Comment
Need Help
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

I think for this part:

 

 IF(ISFILTERED('Table1'[Resource_Type]) = "Employee", Employee_Utilization, Contractor_Utilization)

 

You want

 

IF(MAXX('Table1',[Resource_Type]) = "Employee" ...

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    Thanks for the reply. I tried it, however, it says parameter is not of correct type, and also cannot find [Resource_Type].