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.
Hello everyone,
I have a dax for calculating average of hour of teacher by contract by month as below :
But I want the column Total is average of all of months , not is the sum of all this average in Power BI
I have a power BI in this link : https://drive.google.com/file/d/13J44Tg-b_ixRSpYRcEp2noUD_tKTbLhl/view?usp=drive_link
Please help me for calculating the average of an average ! Thank you very much
Solved! Go to Solution.
hi @Simple_one
Please try this
Simplified the measure. Result on the bottom right table.
hi @Simple_one
Please try this
Simplified the measure. Result on the bottom right table.
User | Count |
---|---|
68 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
123 | |
42 | |
39 | |
26 | |
24 |