Measure to Count only if it's more than once

[arythedj]

Hi, I have a report like below:

The data is like below:

As you cans see, my current slicer is for Zone ID = 7 and date from 15th June to 17th June.

Total Orders = 9 (in above image there are 9 rows of order_id)

Totac Customers = 6 (in above image, there are 6 unique values of Customer ID)

In my report, I need to add another measure for Total Customers who make more than 1 order. In this example the result should be 3. So report should look like this:

Really appreciate it if someone can help me.

Regards,

Ary

[amitchandak · Accepted solution]

@arythedj , Not sure about order id column and its aggregation,

Assumed order id and count for that.

Try like

countX(filter(summarize(Table, Table[customer_id], "_1", count([Order ID])),[_1]>1),[customer_id])

[arythedj]

@amitchandak it works like a charm.

Thank you so much!

Ary