DAX query for SQL IN statement

[Anonymous]

Hi Everyone,

I have a SQL Query which I need to build in DAX:

Select Sum (XXX) from table

where (some other conditions) and

Table.col IN ( 
                                Select ABC from Table2 where Col1 = "AAA")

Can somebody help

[Mahesh0016]

Measure = calculate(sum(xxx),filter(table[name],(some other conditions) and CONTAINSROW ( { "Red", "Blue", "Yellow" }, Table[col] )))

@Anonymous i hope this post helps.