Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

NOT IN dax showing wrong counts

I am trying to write a DAX statement for NOT IN but i don't know the syntax for it. It's like:   CALCULATE(sum(C[T_S]),C[S] <> "C" || C[S] <> "V" || C[S] <> "D" || C[S] <> "C")   Eventhough, I m...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    You could change to it.

    q =
DIVIDE (
    CALCULATE (
        SUM ( C[T_S] ),
        FILTER ( C, NOT ( C[S] ) IN { "C", "V", "D", "C" } )
    ),
    SUM ( T_D[T_S] )
)


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Try like

CALCULATE(sum(C[T_S]), Filter(C, not( C[S] in {"C" ,V","D","C"} ) ) )