Forum Discussion

sergioquerido's avatar
sergioquerido
Icon for Helper I rankHelper I
2 years ago
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...
Need Help
  • ahadkarimi's avatar
    ahadkarimi
    2 years ago

    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])))

ahadkarimi's avatar
ahadkarimi
Icon for Solution Specialist rankSolution Specialist
2 years ago

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's avatar
sergioquerido
Icon for Helper I rankHelper I
2 years ago

Nice solution. Worked. Thank you!