Hello, @Roboboboberts !
Please, find in attached file.
What i did:
on the row level of “Region” (when “Region” has value in the table) add classical formula for average:
sum of the volumes in the table column divide number of rows in that column.
using summarize and sumx:
New measure called “MAPE 1”
Please help .(.xlsx (143.8 KB)
=IF(
HASONEVALUE(Table1[Region]);
– check, if on the row level of a table has “Region” values
– if “yes”, just calculates SUM of MAPE values and divide it on ROW Num
SUMX(
SUMMARIZE(‘Table1’;
Table1[Region];
‘Table1’[Market];
‘Table1’[Product];
“MAPE_0”;
‘Table1’[MAPE]);
[MAPE_0]) / COUNTROWS(‘Table1’);
– if “No”, returns automatically calculated MAPE value
‘Table1’[MAPE])
at the total level just auto calculated MAPE value.
Sometimes could face such cases - like described here: Fix Incorrect Totals
Hope, this helps you!
BR,
Oleg