Calculate Average

[Zaky]

Hi,

Need help.

What is the measure to calculate average value for each Stage below?

Stage 0

Stage A-C

Stage D

and the following is the data

Stage	TA SR Creation
A	1
0	0
0	7
0	4
0	5
0	0
0	6
A	0
A	1
0	1
0	0
A	1
A	7
0	48
0	54
A	8
0	56
A	1
0	59
A	0
A	0
0	76
C	20
A	3
A	21
A	33
A	0
C	0
B	47

[ryan_mayu · Accepted solution]

@Zaky 

you can create a new group for stage

then create a measure

Measure = average('Table'[TA SR Creation])

[Zaky]

Hi @ryan_mayu 

Wonderful. It solved the problem.

Thank you very much for your help!

Regards

Zaky

[ryan_mayu]

you are welcome