Count Unique ID's by Internet Orders


#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.