Counting average using New Measures

[jinweitan]

Hi all,

I have my resource table as below:

Type	Score
Maths	80
Maths	90
English	80
English	100
Geography	90
Georgraphy	null
English	null

I would like to count Average for each type, so I can present data as such on my Power BI report

Type	Average Score
English	85
Maths	90
Georgraphy	100

Is there a way to do it through New Measures?

Many thanks

[Icey]

Hi @jinweitan ,

Please check if this is what you want:

Avg Measure =
VAR Count_Type =
    COUNT ( 'Table'[Type] )
VAR Sum_Score =
    SUM ( 'Table'[Score] )
RETURN
    DIVIDE ( Sum_Score, Count_Type )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@jinweitan , How come english is 85 and geography is 100

ideally a meausre  Avergae(Table[Score]) should do