Hi,
I want to calculate Average score and avg risk score using period and ID using DAX,
I need help:
| Record | Period | ID | Total risk | Avg Score | Avg Risk Score |
| 1 | 1 | A | 7.4 | =AVERAGEIFS(G$6:G$30,F$6:F$30,F6,E$6:E$30,E6) | =AVERAGEIFS(H$6:H$30,E$6:E$30,E6) |
| 2 | 1 | A | 11.5 | 8.5 | 8.8 |
| 3 | 1 | A | 6.8 | 8.5 | 8.8 |
| 4 | 1 | A | 10.0 | 8.5 | 8.8 |
| 5 | 1 | A | 6.7 | 8.5 | 8.8 |
| 6 | 1 | B | 7.5 | 9.6 | 8.8 |
| 7 | 1 | B | 10.3 | 9.6 | 8.8 |
| 8 | 1 | B | 10.1 | 9.6 | 8.8 |
| 9 | 1 | B | 9.2 | 9.6 | 8.8 |
| 10 | 1 | B | 11.1 | 9.6 | 8.8 |
| 11 | 1 | C | 9.5 | 8.5 | 8.8 |
| 12 | 1 | C | 8.2 | 8.5 | 8.8 |
| 13 | 1 | C | 8.2 | 8.5 | 8.8 |
| 14 | 1 | C | 7.9 | 8.5 | 8.8 |
| 15 | 1 | C | 8.9 | 8.5 | 8.8 |
| 16 | 1 | D | 9.5 | 8.7 | 8.8 |
| 17 | 1 | D | 8.1 | 8.7 | 8.8 |
| 18 | 1 | D | 7.1 | 8.7 | 8.8 |
| 19 | 1 | D | 10.1 | 8.7 | 8.8 |
| 20 | 1 | D | 8.6 | 8.7 | 8.8 |
| 21 | 2 | A | 9.9 | 8.5 | 8.5 |
| 22 | 2 | A | 7.1 | 8.5 | 8.5 |
| 23 | 2 | A | 9.6 | 8.5 | 8.5 |
| 24 | 2 | A | 7.9 | 8.5 | 8.5 |
| 25 | 2 | A | 8.1 | 8.5 | 8.5 |
