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
amitchandak's avatar
amitchandak
Super User
4 years ago

tobisw , This formula, will avg above 'Plants'[MRP Contr.] level

 

AVERAGEX(
KEEPFILTERS(VALUES('Plants'[MRP Contr.])),
CALCULATE([Actual_range])
)

 

or

 

AVERAGEX(
VALUES('Plants'[MRP Contr.]),
CALCULATE([Actual_range])
)

 

 


Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • 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.