Monday, 27 July 2020

NOT IN in Power BI DAX query

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

No comments:

Post a Comment