Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I would like to calculate the average of materials ordered in the same day by customers.
I was able to create an average that gives me the number of orders per customer:
However, when I try to create the average, it is not working. The measure I used is:
I created a power bi example with a dummy data that you can find here:
Dummy Power BI
Thanks in advance for helping me!
Solved! Go to Solution.
Hi,
I do not know how you arrived at your denominator (7) for your test measure but you can simplify your existing measure to
I consider a order the combination from customer and date. Thus, I want to do an average of how many products are sold per order.
So, it is necessary to count the IDNR per group (customer and date) and then average in the end.
The 7 comes because I have 7 rows in the table. 7 different combinations of customers and dates.
@lbendlin achieved that by using summarize and it works!
so thank you anyway.
Kind regards,
Jéssica
@lbendlin thank you! exactly what I wanted. and much simpler that I was thinking 😄
I did not know summarize yet. thanks!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |