Forum Discussion

phesc's avatar
phesc
New Member
7 years ago
Solved

Dynamic weighed average time serie

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 a...
Need Help
  • phesc's avatar
    phesc
    7 years ago

    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.

    Dynamic Average

    Regards,

     

    Ph.

v-frfei-msft's avatar
v-frfei-msft
Community Support
7 years ago

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's avatar
phesc
New Member
7 years ago

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.

Dynamic Average

Regards,

 

Ph.