If statement producing DAX Comparison error

[WxShady13]

I am attempting to use the below measure to compare a concatenated column. When I get the 1, 2, 3, 4 then I can use another measure to accurately determine Employee TO %. The formula worked fine when it was just comparing FT or PT, however now that it is comparing FT2021, FT2022, etc. it is giving me the Dax Comparison Operations do not support comparing values. The concatenated column is text exactly like the FT/PT column so I am not sure what is causing the error.

 

[RoryA]

You've put an = instead of a comma in the section for 3:

IF(Prototype[Concat FTPT and Year] = "PT2021" = 3,

should be:

IF(Prototype[Concat FTPT and Year] = "PT2021", 3,

 

[WxShady13]

OMG Thank you! I cannot believe I did not see that.

 

[RoryA]

Glad we could help.