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:
Solved! Go to Solution.
Hi,
Drag Client to a Table visual and write this measure
Measure = Distinctcount(DetalleArreglos[Order Date])
Hope this helps.
Hi,
Drag Client to a Table visual and write this measure
Measure = Distinctcount(DetalleArreglos[Order Date])
Hope this helps.
That worked! Thanks a lot
You are welcome.
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])
)
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.
I cannot read spanish, sorry.
Have sample raw data in Excel and copy, paste here.
Have expected data in Excel and copy, paste here.
Answer =
CALCULATE(
COUNTROWS(yourtable),
ALL(youtable[dates])
)
User | Count |
---|---|
106 | |
81 | |
73 | |
48 | |
47 |
User | Count |
---|---|
157 | |
89 | |
81 | |
69 | |
67 |