If dax with columns

[22LACMT]

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 surrport compairing values of type text with values of type 

DAX:   SFFandCCRC_indicator =

var blue = SELECTEDVALUE(ProviderInfo[SFF])

var green = SELECTEDVALUE(PIPastMonth1[Special Focus Status])

return if(OR(blue =  or("SFF", "SFF Candidate"), (green = or("SFF", "SFF Candidate"))), "True", "False")

[22LACMT]

Im missing something there should be 12 records and there are none marked as true

[Greg_Deckler]

@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")

[22LACMT]

Hi, 

everything is showing as false and their should be 12 true.  do you think it is the selected value. 

[Anonymous · Accepted solution]

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[22LACMT]

thank you, can I ask what || mean