Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
hi,
i want to calculate the average of the values in the line.
the line is calculated by divideing two calculated measures, both are 'max' measures.
how can i calculate the average? i think that sum(max(..)) won't give the correct number.
thanks!
i will be more clear
i have a measure whice is a division of two measures.sum(measure1)\Sum(measure2) for example:
200/1921 = 10.41%
162/1830= 8.85 %
I want to calculate the average of this measure,
the results are
(200+162)/ (1921 + 1830)=9.65%
(10.41+8.85)/2=9.63% - i want to get this measure
thanks!
Hi @MP_123,
Based on your information, it's difficult to reproduce your scenario, do you mind post your sample data or .pbix file for further analysis?
Best Regards,
Angelia
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.