Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Im new to Power Bi and im having trouble with the Matrix Col adding up to the correct totals. I think I need a HASONEFILETR calc but im not sure how to do it.
I have 3 tables
Any help would be appreciated.
AssignmentMaterialWork x PowerW =
(SUM('Assignments'[AssignmentMaterialWork]) * SUM('ResourceData'[PowerW])/1000)
Solved! Go to Solution.
This is probably an order of operations issue. Sum then Multiply will not produce the same answer as Multiply then Sum.
So I think the following might fix your issue:
AssignmentMaterialWork x PowerW =
(SUMX('Assignments', 'Assignments'[AssignmentMaterialWork] * (RELATED('ResourceData'[PowerW])/1000))
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
This is probably an order of operations issue. Sum then Multiply will not produce the same answer as Multiply then Sum.
So I think the following might fix your issue:
AssignmentMaterialWork x PowerW =
(SUMX('Assignments', 'Assignments'[AssignmentMaterialWork] * (RELATED('ResourceData'[PowerW])/1000))
Thanks this fixed it, appreciate the help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |