Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI ,
I need help on one to many relationship.
I three tables :
This is a mock re-creation of the type of data fields and data in the three tables
I need to create a table listing RLS Date and (1) Count of Steel ID (2) Total weight against Steel ID. Although Count of ID is giving the correct result , the weight is not showing correct total. It will be great help if the forum can advise why am I getting the total of all weight for each RLS Date and not the total against each date. How can we resolve this.
This is how it looks like currently.
Thanks.
Solved! Go to Solution.
Your Date and Hold Measures are not filtering your Inventory measures table. You can pass the SteelID values over to that table with TREATAS. See if this gets your expected result.
New Sum = CALCULATE(SUM(Table3[Weight]), TREATAS(VALUES(Table2[SteelID]), Table3[SteelID]))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Your Date and Hold Measures are not filtering your Inventory measures table. You can pass the SteelID values over to that table with TREATAS. See if this gets your expected result.
New Sum = CALCULATE(SUM(Table3[Weight]), TREATAS(VALUES(Table2[SteelID]), Table3[SteelID]))
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks a lot , It worked.