Forum Discussion

tobisw's avatar
tobisw
Regular Visitor
4 years ago

Average Calculation

Hello everybody,   i´m struggeling with a average calculation in my power bi report. Target what i would like to achieve is, to calculate the  Range of Coverage as average of all parts of a MRP c...
Need Help
tobisw's avatar
tobisw
Regular Visitor
4 years ago

You mean, that my formula is not correct? Sorry, i´m not sure if i understood your right. By using your formula the result is the same...

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi tobisw ,

 

I have a test by your code. And get result as below.

I think the average of "Acutal_range" in each [MPR Controller] is correct.

For [MPR Controller] = 500, average of "Acutal_range"  = 3/1

For [MPR Controller] = 600, average of "Acutal_range"  = 166/1

Subtotal = (3+166)/2

Could you show a screenshot with the result you want to me?

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.