Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there! I'm hoping all the smart people out there can help me with this.
I need a measure that will divide budgeted_hours by the estimated_units in another table. The caviat is that I have a quantity basis I need referenced in order to do find the right estimated_units. So for example:
Job #1 has budgeted labor hours for the following activities:
Job #1 also has budgeted quantities that we are producing and each quantity type corresponding to the activity above:
I would like to have a measure that would tell me for Job #1 I have 50 hours per set-up (50 hours divided by 1 set-up) and that I have 20 hours per beam for casting (100 hours divided by 5 beams) and 2 hours per beam for patching (10 hours divded by 5 beams).
I have attached the two tables and how the are linked:
it should be something like psi-labor_budgets[budgeted_hours] / psi-qty_budgets[orig_est_units] ... but then filtered or realted to the cost_basis.... I know all the smart folks out there can help me with this one! thanks in advance!!
Jim
Solved! Go to Solution.
@jyeager - You will need to use RELATEDTABLE or you could use LOOKUPVALUE so something like:
Measure =
DIVIDE(
SUM('psi-labor_budgets'[budgeted_hours]),
SUMX(RELATEDTABLE('psi-qty_budgets'),[orig_est_units]),
0
)
@jyeager - You will need to use RELATEDTABLE or you could use LOOKUPVALUE so something like:
Measure =
DIVIDE(
SUM('psi-labor_budgets'[budgeted_hours]),
SUMX(RELATEDTABLE('psi-qty_budgets'),[orig_est_units]),
0
)
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |