DAX "NOT IN"

[Anonymous]

Hello ,

Im new to power bi,
can someone help me ?

How to filter using Not in ?

Thank you in advance,
Im having a hard time to solve it,
I will advance also..I dont like to subtract to get the output..
Thanks

[v-frfei-msft]

Hi @Anonymous ,

You need to place the NOT formula on the column and then use the in to make the level you need.

So you measure should look something like this:

MEASURE NOT IN =
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER (
        Table1, NOT ( Table1[CAT LEVEL] ) IN { 2,3 }
    )
)

[amitchandak]

Typically for NOT In create an IN

not(brand in ('A','B'))

and use not on top of that

[Anonymous]

Good Day Sir,,
Thanks for your Feedback, Can you attached Some examples ?
Sorry for disturbing you

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

You can find the pbix as attached. Also M code for your reference.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSK1YlWMgKTxmDSBEyagkkzMGkOJi2UYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"value", Int64.Type}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [value] > 5 then "ok" else if [value] < 2 then "ok" else null)
in
    #"Added Conditional Column"

[leojhernandez]

Stop posting useless files that do not help to answer the request.