title: How to calculate value for each variable by their percent using DAX Power BI
body: <p>Need your help to solved my problem about DAX Power BI.</p>
  
  <p>So, I'm trying to visualize the total cost for each project that have employee on it using Power BI. but the cost for one employee can be shared to some project by the percentage at every project.</p>
  
  <p>the goal is to calculate the total cost for each employee, then divide it into several project by the percentage.</p>
  
  <p>and here is the excel data.
  so I have 3 table. COST,MASTER USER, AND PAYMENT ALLOCATION.</p>
  
  <p>-COST</p>
  
  <p><a href="https://i.stack.imgur.com/6MJuV.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6MJuV.jpg" alt="COST"></a></p>
  
  <p>-MASTER USER</p>
  
  <p><a href="https://i.stack.imgur.com/UwTUH.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/UwTUH.jpg" alt="MASTER"></a></p>
  
  <p>-PAYMENT ALLOCATION</p>
  
  <p><a href="https://i.stack.imgur.com/qX0k9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qX0k9.jpg" alt="ALLOCATION"></a></p>
  
  <p>And here is the expected result.</p>
  
  <p><a href="https://i.stack.imgur.com/MyxCO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MyxCO.jpg" alt="enter image description here"></a></p>
  
  <p>Please help me solved my problem, Thank you so much!</p>