Dynamic weighed average time serie

[phesc]

I am fighiting to solve a problem: I have a time serie allowing me to compute the success rate of an operation on different regions. I would like to be able to compute the time serie of the weighed average of the success rate over a dynamic filtering on one or several regions.

e.g.

Year Total OK Region

2016 10 8 Europe

2016 15 9 Americas

2016 20 15 Asia

2017 12 10 Europe

2017 16 10 Americas

2017 18 12 Asia

I want to display over the time, bars per region + weighed average according to the highlighted selection in PowerBI!

The problem is on the dynamic nature of the weighed average that depends on the set of regions that are selected.

Is there a way to do this in PowerBI?

Thanks for the help!

[v-frfei-msft]

Hi @phesc,

To create a measure as below. If it doesn't meet your requirement, kindly share your excepted result to me.

Measure = CALCULATE(SUM(Table1[OK]))/CALCULATE(SUM(Table1[Total]),ALL(Table1))

Alsp please find the pbix as attached.

Regards,

Frank

[phesc · Accepted solution]

Thanks a lot, Frank! it is almost what I was looking for and indeed your answer was close to the result I expected, even simpler : just needed to remove the filter "ALL" !

Success rate (%) = CALCULATE(SUM(Sheet2[OK]))/CALCULATE(SUM(Sheet2[Total]))*100

Indeed, it alows to demonstrate one key difference between a column and a measure: the measure is using the current context where it is used then more dynamic.

Regards,

Ph.