Using the IN operator in DAX and not working

Dr_Little · July 2, 2019, 5:53am

Hey guys,

I’m trying to transform this code into a DAX measure:

if (Column1 in ("Value1","Value2"...."ValueN") then [Revenue] else 0)

I need to calculate the (sum(FactT[revenue]), filter(FactT,FactT[Column1] in (“Value1”,“Value2”…“Value3”))).

Other than IN, can anyone here suggest a function that I can use?

Thanks in advance!

Nick_M · July 2, 2019, 4:11pm

you can try:

   CALCULATE(
    [Total Revenue].
    Table[Column] IN {"Value1", "Value2"}
)

sam.mckay · July 3, 2019, 9:41pm

Yes a solid understanding of CALCULATE is required here.

This is some fundamental learning that you should jump into as soon as you can.

Here’s some links to review.

Good luck!

Sam