Avg of Sum by YEAR

[Anonymous]

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

[FrankAT]

Hi @Anonymous,

use the following solution:

Regards FrankAT

[v-eachen-msft]

Hi @Anonymous ,

You could create a new table:

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

[AntrikshSharma]

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

[parry2k · Accepted solution]

@Anonymous add this following measure

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.⚡