Average calculation using multiple variable

[Sriku]

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

[Anonymous · Accepted solution]

Hi @Sriku 

Yeah, since the description is about as clear as mud... I would also like to see anyone calculate it. I can see this post was placed here on Thursday. It's Monday. Which means nobody wants to decipher what the formulae mean. No wonder. I wouldn't do it, either.

@Sriku, please try to read this guide for better results in the future: How to Get Your Question Answered Quickly - Microsoft Power BI Community