Forum Discussion
Data Modelling Issue
Hi sarbjeet,
The repeating Actual Cost means your Finance table rows don't have a work order value at that level, so when the matrix expands to work order, it repeats the Functional Area total.
Fix in 3 steps:
Confirm the data does every Actual Cost row in Finance have a Work Order populated?
Check the relationship Dim_Order → Finance should be single direction, not bidirectional
Use a measure, not a raw column:
Actual Cost = SUM(Finance[ActualCost])
If step 1 is the problem, it's a source data issue, the fix needs to happen upstream before Power BI can split it correctly.
Hope this helps! Feel free to ask if needed. Don't forget to mark as solution and kudos. That's motivate me to keep helping.
Best regards,
Oussama (Data Consultant - Expert Fabric & Power BI)
Memorable MemberHi sarbjeet,
The repeating Actual Cost means your Finance table rows don't have a work order value at that level, so when the matrix expands to work order, it repeats the Functional Area total.
Fix in 3 steps:
Confirm the data does every Actual Cost row in Finance have a Work Order populated?
Check the relationship Dim_Order → Finance should be single direction, not bidirectional
Use a measure, not a raw column:
Actual Cost = SUM(Finance[ActualCost])
If step 1 is the problem, it's a source data issue, the fix needs to happen upstream before Power BI can split it correctly.
Hope this helps! Feel free to ask if needed. Don't forget to mark as solution and kudos. That's motivate me to keep helping.
Best regards,
Oussama (Data Consultant - Expert Fabric & Power BI)
Thank you for the answer. It is working now.
