Total Average Not Correct

[sergioquerido]

Hi,

How can i correct the total avarages of the table for each measure? As you can see in figure attached the total averages of the table is not correct. For instace, the Total Average of variabl "TD" should be 28,34% and not 25,2. 
The code for that measure is: %_TD = DIVIDE([Day_TD],[Final_MatchReferenceTD]).

Thank you

[ahadkarimi · Accepted solution]

Try this one and let me know the result:

%_TD =
IF( HASONEVALUE(Table[Player]),
DIVIDE([Day_TD],[Final_MatchReferenceTD]),
AVERAGEX(
VALUES(Table[Player]),
DIVIDE([Day_TD],[Final_MatchReferenceTD])))

[sergioquerido]

Nice solution. Worked. Thank you!

[mickey64]

For your reference.

Please use 'EXPANDALL' function.

 Ex.) Average of leaf level = EXPANDALL(AVERAGE([%_TD]), ROWS)

Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn

[sergioquerido]

EXPANDALL function is not working. Thank you.