Forum Discussion
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 want the average of the PPH to show up in the "Total" at the bottom. I'm affaird its giving me the total PPH dividied by the number of days. The numbers aren't coming out correctly. The PPH is basically the "Finished Product" divided by the number of hours worked. Any help would be greatly appreicated.
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.
8 Replies
I think you want to use AVERAGEX
Here is how the table looks. Can you show me how to type out the averagex code?
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.
