Forum Discussion
Solved
Total Average Not Correct
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 "T...
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])))
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
EXPANDALL function is not working. Thank you.
