Forum Discussion
Power Bi Pro Desktop Trouble with average in Matrix table
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.
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.
It gives me an error. If you look back at the original table. The PPH value at the bottom in the "Total" row should be Finished Product divided by Sum of Hours worked. We take the number of pieces produced and divide that by the number of hours worked. This gives us the operators pieces per hour metric. The PPH in the Total row now is not accurate. It should read 46.87 because 5508/117.51 is 46.872606 but we only use two decimal spots, so 46.87.
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.
Very good man. It works.
Hey I have another question for you. It's in the same report. I'm trying to add these 3 columns to get a total.. and the DAX formula that I'm using is coming out all messed up.
TA = SUMX('RawData', RawDATA[Total Assemblies for Above Cell During Selected Shift]+RawDATA[Total CUT TO LENGTH pieces for Above Cell During Selected Shift]+RawDATA[Total PARFLEX pieces for Above Cell During Selected Shift])Thats what I'm using. But if you look at the second picture once I select the measure to add to the table it doesn't compute correctly. I think the reason might have to do with somedays there are multiple entries for the same cell. Cell 2 might have multiple entries because part of the day they worked on assemblies and another part of the day they worked on CTLs.