Count number of times value appears on different dates

[admtb20]

Hello everyone!

I'm trying to produce a report that shows how many purchases a client has made on different dates, given that a person can make multiple purchases on the same day. This is what I'm trying to achieve:

[Ashish_Mathur · Accepted solution]

Hi,

Drag Client to a Table visual and write this measure

Measure = Distinctcount(DetalleArreglos[Order Date])

Hope this helps.

[admtb20]

That worked! Thanks a lot

[Ashish_Mathur]

You are welcome.

[sevenhills]

Say, if your table has these columns "Order Date, Client Name, Order ID"

Count of Client Orders = 
CALCULATE( 
   DISTINCTCOUNT('table'[Order ID]), 
   ALLEXCEPT('table', 'table'[Order Date], 'table'[Client Name],'table'[Order ID])
)

[admtb20]

I only have Order Date and Order ID. This is what I have in the actual model

Order Count = CALCULATE(
DISTINCTCOUNT(DetalleArreglos[Order ID]) ,
ALLEXCEPT(DetalleArreglos , DetalleArreglos[Order Date], DetalleArreglos[Order ID]))

Taking the first ID as an example, this is the raw information

The ID appears on 5 different dates and that is what I want the model to show.

[sevenhills]

I cannot read spanish, sorry.

Have sample raw data in Excel and copy, paste here.

Have expected data in Excel and copy, paste here.

[speedramps]

Answer =
CALCULATE(

COUNTROWS(yourtable),

ALL(youtable[dates])

)