Filtered Calculated Measure

[Anonymous]

Hi There,

I am attempting to create a multi-filtered calculated measure in Power BI. Something like this: 

If Dimension contains Facebook OR Instagram OR Youtube, then sum(Column1), else Column2. 

Can someone help me with the DAX required to generate this output? 

[v-yiruan-msft]

Hi @Anonymous ，

Not sure if you have solved your problem, if not, you can create a calculated column just like @edhans  provided. You can refer to the PBIX file or the details

Best Regards

Rena

[edhans · Accepted solution]

You want to use the IN operator.

See this article.

It would basically be something like:

Measure :=
IF (
    table[field] IN { "Facebook", "Instagram", "Youtube" },
    SUM ( table[field1] ),
    SUM ( table[field2] )
)