Hi All,
If you cannot get the NOT IN function working in power BI then use it like below
MEASURE NOT IN =
CALCULATE (
SUM ( Table1[Value] );
FILTER (
Table1;
Table1[Category] = "C"
&& NOT ( Table1[CAT LEVEL] ) IN { 2; 3 }
)
)
I,e use NOT before the table name and IN before column name
If you cannot get the NOT IN function working in power BI then use it like below
MEASURE NOT IN =
CALCULATE (
SUM ( Table1[Value] );
FILTER (
Table1;
Table1[Category] = "C"
&& NOT ( Table1[CAT LEVEL] ) IN { 2; 3 }
)
)
I,e use NOT before the table name and IN before column name
No comments:
Post a Comment