cancel
Showing results for
Did you mean:
Highlighted
Helper IV

## Avg of Sum by YEAR

Hi, I have this dataset:

The Teams have points by Year..

I need the Average of Points for each Team taking into account all the years.

Which is the best way to create this using DAX?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User VII

## Re: Avg of Sum by YEAR

``Avg = AVERAGEX ( VALUES ( 'Avg'[Year] ), CALCULATE ( SUM ( 'Avg'[Points] ) ) )``

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

4 REPLIES 4
Highlighted
Super User VII

## Re: Avg of Sum by YEAR

``Avg = AVERAGEX ( VALUES ( 'Avg'[Year] ), CALCULATE ( SUM ( 'Avg'[Points] ) ) )``

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Highlighted
Super User II

## Re: Avg of Sum by YEAR

``````Avg Points =
AVERAGEX (
VALUES ( Table[Team] ),
CALCULATE ( SUM ( Table[Points] ), ALL ( Table[Year] ) )
)``````

Proud to be a Super User!

Thank you,
Antriksh Sharma
Highlighted
Community Support

## Re: Avg of Sum by YEAR

Hi @pisanoagus ,

You could create a new table:

``````Table 2 =
SUMMARIZE (
'Table',
'Table'[Team],
"AVG POINTS", ROUND ( AVERAGE ( 'Table'[Points] ), 1 )
)``````

If this post helps, then please consider Accept it as the solution to help the other members find it.
Highlighted
Super User II

## Re: Avg of Sum by YEAR

Hi @pisanoagus,

use the following solution:

Regards FrankAT

Announcements

#### Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors