Forum Discussion

tyjames05's avatar
tyjames05
Helper I
2 years ago
Solved

Power Bi Pro Desktop Trouble with average in Matrix table

Hello all,   I'm having trouble with the average in my matrix table. I've looked at other threads with similiar problems and I don't seem to figure it out. I have a column in my table call "PPH". I...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, tyjames05 

     

    You can try the following methods.

    Measure:

    PPH = AVERAGEX(ALL('Table'),DIVIDE(SUM('Table'[Finished Product]),SUM('Table'[Hours Worked])))

    Is this the result you expect? Please see the attached document.

     

    Best Regards,

    Community Support Team _Charlotte

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

v-zhangti's avatar
v-zhangti
Community Support
2 years ago

Hi, tyjames05 

 

You can try the following methods.

Average = AVERAGEX('Table',[PPH])Average = AVERAGEX('Table',[PPH])

Is this the result you expect? Please see the attached document.

 

Best Regards,

Community Support Team _Charlotte

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

tyjames05's avatar
tyjames05
Helper I
2 years ago

When I'm putting in the date to the spreadsheet, I have a column for PPH. I manually put this in. Lets say we left it out and we created a new measure to divide the finished product by total hours worked, would that then create the correct PPH in the total row at the bottom?