Forum Discussion
Modeling and Calculations
Create below relationship :
Component Table --> Future Plan (one to many based on ProductID with corss filter direction "Single")
Future Plan --> Product Table (One to one based on ProductID with cross filter direction "Both")
hitesh160790 In your original post the relationship was good. Although Tahreem24 solution would have worked given the sample data I think you need to keep the same relationship in and use the measure to do the job.
I have put together sample data of 2 products and multiple recipes for one of the product and multiple buys and everything should work.
See attached, it contains many tables but just focus on Product/Receipt and Product Future table and a measure in the product table. You can tweak it from here.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Create below relationship :
Component Table --> Future Plan (one to many based on ProductID with corss filter direction "Single")
Future Plan --> Product Table (One to one based on ProductID with cross filter direction "Both")
Thanks a lot, it worked. Just a small change I did,
Component Table --> Future Plan (one to many based on ProductID with cross filter direction "BOTH") was used here instead of another table.
Thank you