Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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])
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
96 | |
90 | |
79 | |
67 |
User | Count |
---|---|
157 | |
125 | |
116 | |
111 | |
95 |