Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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])
)