Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
@Anonymous , Try a measure like
divide(sum(Table[Period Hours]), sumx(summarize(Table, Table[Phase Code], Table[Period Qty]),[Period Qty]))
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
@Anonymous , Try a measure like
divide(sum(Table[Period Hours]), sumx(summarize(Table, Table[Phase Code], Table[Period Qty]),[Period Qty]))
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |