topic If dax with columns in Developer

If dax with columns

22LACMT — Mon, 16 Oct 2023 17:19:19 GMT

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

Re: If dax with columns

Greg_Deckler — Mon, 16 Oct 2023 18:20:18 GMT

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

Re: If dax with columns

22LACMT — Mon, 16 Oct 2023 19:47:57 GMT

thank you, can I ask what || mean

Re: If dax with columns

22LACMT — Mon, 16 Oct 2023 20:53:11 GMT

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

Re: If dax with columns

22LACMT — Tue, 17 Oct 2023 13:10:36 GMT

Hi,

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

Re: If dax with columns

Anonymous — Wed, 18 Oct 2023 05:48:17 GMT

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.