Forum Discussion

xariet's avatar
xariet
Helper I
3 years ago
Solved

Calculating Average

Hi All, I need to do a very simple calculation, but I am stuck. Please help. I need to see in the table the countries, years, and average per country across all years. I have tried different variatio...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi xariet 

    Try :

    average over years =
    CALCULATE(
        AVERAGE('table'[Sum]),
        ALLEXCEPT('table', 'table'[Country])
    )

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

  • xariet's avatar
    xariet
    3 years ago

    Thank you Ritaf1983 , but using your formula I still get incorrect numbers

     

Ritaf1983's avatar
Ritaf1983
Super User
3 years ago

Hi xariet 

Try :

average over years =
CALCULATE(
    AVERAGE('table'[Sum]),
    ALLEXCEPT('table', 'table'[Country])
)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

xariet's avatar
xariet
Helper I
3 years ago

Thank you Ritaf1983 , but using your formula I still get incorrect numbers