change of aggregation when drill up/down

[edgar_crz]

Hi Community,

New on power BI I have created a report where i want to present my KPis at different levels 

1) Region (EMEA)

2) Managing entity (ex : Estern europe)

3) Country

It worked perfectly for stock level as it is a simple sum when driling up/down

But for forecast accuracy for instance, i would like a weighted average by total sales when showing the data at managing entity & EMEA level... I only figured out how to show the data with a simple average...

Do you know if it is possible ? And if yes do you have any ideas how i could manage this ? 

(I wanted to attached to file but it does not seem possible so i did screen capture... sorry!)

Many thanks !

Edgar

[edgar_crz]

Sorry for disturbing, i finally found out a after some digging.

I only needed to create a new with a weighted average and the drill down now works perfectly !