Forum Discussion

jyeager's avatar
jyeager
Icon for Helper I rankHelper I
6 years ago
Solved

Help Needed! Divide Column in One Table by Column in Another Table

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 q...
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    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
  )

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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
  )