Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |