Forum Discussion

sw123's avatar
sw123
Helper III
4 years ago

Help with calculation

Hi, Can someone help me with this? I have three tables: Report, Holes and Recipe.   Report: Report Id: 1 2 3 4 5 6   Holes: Hole Id         Recipe Id           Report Id 1              ...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

sw123 although lbendlin solution will work and it is a great solution but another approach could be to avoid adding a new column in the Holes table, you can achieve this by using the following measure, and then use this measure in the visualization:

 

Preset Kg = SUMX ( Holes, RELATED ( Recipe[Preset KG] ) )

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!