Forum Discussion
Solved
If dax with columns
Hi Im trying to write the below if statement. the if funtion wants the 2 columns to be measures. so I used the selecedvalue to turn the columns into measures. but I am getting the error: do not su...
Hi 22LACMT ,
As far as I know,"||" should be OR function in Dax. Grey's code should work and please check your data model.
Also you can update your code as below.
SFFandCCRC_indicator = VAR blue = SELECTEDVALUE ( ProviderInfo[SFF] ) VAR green = SELECTEDVALUE ( PIPastMonth1[Special Focus Status] ) RETURN IF ( OR ( blue IN { "SFF", "SFF Candidate" }, green IN { "SFF", "SFF Candidate" } ), "True", "False" )You can download my sample file to learn more details.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
22LACMT I *think* you want this:
var blue = SELECTEDVALUE(ProviderInfo[SFF])
var green = SELECTEDVALUE(PIPastMonth1[Special Focus Status])
return
if( blue = "SFF" || blue = "SFF Candidate" || green = "SFF" || green = "SFF Candidate", "True", "False")
thank you, can I ask what || mean