Forum Discussion
Helper IINeed Help with Calculating Unweighted Averages at Multiple Hierarchical Levels in Power BI
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Thank you so much for taking the time to look into my problem. The issue is now resolved – and I don’t know what happened. I was playing around with the numbers without changing the measures – and suddenly the correct number appeared. Strange!!!
Community SupportHi Fia123
It sounds good. could you please accept my solution 😊. It will help others to find more easily.
Helper IIHi,
As I mentioned in my previous email, the issue suddenly resolved itself, and the numbers were correct. Now, I’m working in a different report, and the same problem has appeared again.
When I calculate the average at the top level (AVG_Kat1), I get an incorrect value. The correct value is 5.89 (5.77 + 6.0)/2), but I am getting 5.86.
Power BI gives:
Kat1 Avg_Kat1
--------------------
Pre-K 5,77
Toddler 6,01
--------------------
Total 5,86
I got the following data:
Tabel: FKSS
| Kat1 | Kat2 | Kat3 | Value |
| Pre-K | CO | BM | 6,75 |
| Pre-K | CO | ILF | 6,75 |
| Pre-K | CO | PD | 6,75 |
| Pre-K | ES | NC | 7 |
| Pre-K | ES | PC | 7 |
| Pre-K | ES | RSP | 6,63 |
| Pre-K | ES | TS | 6,75 |
| Pre-K | IS | CD | 3,5 |
| Pre-K | IS | LM | 3,63 |
| Pre-K | IS | QF | 4 |
| Toddler | EBS | BG | 6,88 |
| Toddler | EBS | NC | 7 |
| Toddler | EBS | PC | 7 |
| Toddler | EBS | RCP | 7 |
| Toddler | EBS | TS | 6,75 |
| Toddler | ESL | FLD | 5,25 |
| Toddler | ESL | LM | 6,13 |
| Toddler | ESL | QF | 3,88 |
Avg_Kat2 = Averagex(
SUMMARIZE(FKSS, FKSS[Kat2], FKSS[Kat3],
"Avg_Kat3",[AVG_Kat3]),
[Avg_Kat3])
Avg_Kat1 =
AVERAGEX(
SUMMARIZE(FKSS,FKSS[Kat1],FKSS[Kat2],
"Avg_Kat2",
AVERAGEX(
SUMMARIZE(
FKSS,
FKSS[Kat2],
FKSS[Kat3],
"Avg_Kat3", AVERAGE(FKSS[Value])
),
[Avg_Kat3])),
[Avg_Kat2])
I would be very grateful if someone could help me understand the incorrect result.
Tove