Forum Discussion
Zaky
4 years agoHelper IV
Calculate Average
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 |
you can create a new group for stage
then create a measure
Measure = average('Table'[TA SR Creation])