cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## SUM of AVERAGE

Hi All,

My table have a measurment called "Average ORSO", which is an averaged value of a column ORSO_ER

and i added a Martix Visual, want to calcuculate the SUM of "Average ORSO", however the martix calculated the

average of the "Average ORSO" instead of SUM, may i know where can i change it ?

best regards,

Joey

1 ACCEPTED SOLUTION
Solution Sage

You can go through the following thread to understand the issues with incorrect measure totals

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Further you can go through the video below to understand the measure totals.

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan

2 REPLIES 2
Solution Sage

You can go through the following thread to understand the issues with incorrect measure totals

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Further you can go through the video below to understand the measure totals.

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

Regards,

Affan

Super User

If I understand correctly, you want a behaviour at the total different from that at the single rows (SUM vs AVG).

For that I think you need to first check where the measure is operating , if at the total or not, and then use a different formula. The idea:

IF @TOTAL do SUM...

else

do AVERAGE

You can do the check with HASONEVALUE(  ), SELECTEDVALUE( ) or something similar

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.