Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |