Contains with more than one value

[Anonymous]

Hi,

Im trying to create a measure to replace specific values in a visual table with N/A where not applicable.

I can get the code to work for one row (351), but I dont know how to put multiple values in the contains?

Could somebody please help?

My code is below.

Test = IF (

          CONTAINS(vwtest,vwtest[Key],351),"N/A"

         ,CALCULATE(

         SUMX('vwtest', [Count]), 'vwtest'[Breached] = "Y") + 0 )

Thanks

Liam

[Anonymous · Accepted solution]

Try this 

Test = IF (

         max(vwtest[Key]) in {351,352,353},"N/A"

         ,CALCULATE(

         SUMX('vwtest', [Count]), 'vwtest'[Breached] = "Y") + 0 )

I don't know why are you adding 0 at the end.

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

[Anonymous]

Thanks @Anonymous 

That worked perfectly. The + 0 fills in my blanks with zeros,

[Pragati11]

Hi @Anonymous ,

You can use something like this as follows:

                                                                     CONTAINS(InternetSales, [ProductKey], 214, [CustomerKey], 11185)

Refer following link:

https://docs.microsoft.com/en-us/dax/contains-function-dax

If this helps please give Kudos and mark it as a Solution! 🙂

Thanks,

Pragati