Using the IN operator in DAX and not working

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! :smile:

you can try:

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


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!