Opposite of IN in dax

[Anonymous]

Hello Team,

I am need a dax formula to calculate a distinct count of sell_to_customer_name where sell_to_customer_no does not contain "99997","99998" and "99997". My table name is sales_main.

I am trying the below formula but it is not working:

Calculate([Sell_name_dist], Sales_main[Sell_to_Customer_No] <> {"99999","99998","99997"})

Sell_name_dist =

DISTINCTCOUNT(Sales_main[Sell_to_Customer_Name])

Any idea on how I can get it to work?

Many Thanks.

Kind Regards,

Hasvine

[DOLEARY85 · Accepted solution]

Hi,

try this

NOT IN =

CALCULATE (

    DISTINCTCOUNT ( 'Sales_main'[Sell_name_dist] ),

    FILTER (

        'Table',

         NOT ( 'Sales_main'[Sell_to_Customer_No]) IN { "99999","99998","99997" }

    )

)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍