Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Hasvine2022
Helper I
Helper I

Opposite of IN in dax

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
1 ACCEPTED SOLUTION
DOLEARY85
Super User
Super User

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 👍

 

View solution in original post

1 REPLY 1
DOLEARY85
Super User
Super User

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 👍

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.