Divide sum of values by single group value

[Anonymous]

Hello,

I have a table where one of the columns qty is shown as the full Phase code qty and not the single line item.

For example in the table below the period qty is 45 for the full phase code 12345 not 90. The hours are shown on the individual row/category level however. 

What I need is to find a way to divide the sum of the hours (2300) by the group period quantity (45).

Phase Code	Category	Period Qty	Period Hours	Expected Hours/QTY
12345	01	45	1800	51.1
12345	02	45	500	51.1

I'm a bit stuck - does anyone have advice for a good way to do this?

Thanks in advance!

[Anonymous]

Thank you @amitchandak I'll try that out!

[Anonymous]

HI @Anonymous,

DId amitchandak 's suggestion help for your scenario? If that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements to find this more quickly.

If not help, please share some more detailed information to help us clarify your requirements.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , Try a measure like

divide(sum(Table[Period Hours]), sumx(summarize(Table, Table[Phase Code], Table[Period Qty]),[Period Qty]))