Count Unique ID's by Internet Orders

DAX DAX Calculations
1

Hello, I have a table with Sales that contain Customer ID’s and Internet Orders. We sell both offline and online. So not every order has a Internet ID. Both Customer ID’s and Internet Order Numbers are set up as a Text Field. I want to count the number of Unique Customers Id’s who have Internet Orders. I’m not getting the number in the calculation as when I filter down.

Thanks

3

Thanks for your patience on this one.

This shouldn’t be too difficult.

I technique like this should solve it.

First work out how many Internet Orders a customer has using a simple COUNTROWS

Internet Orders = 
COUNTA(InternetOrdersColumn)


Then

Customers w/Internet Orders = 
CALCULATE( DISCOUNTCOUNT( Customer ID Column),
         FILTER( SalesTable, [Internet Orders] > 0 )

This should do it I’d say.

1 Like