Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I have a problem about row total in metrix with measure.
If my metrix have one data row > row total is correct, otherwise row total is incorrect.
My measure: DIVIDE(SUM(Revenue[SO portion])*SUM(Team[Team manday %]),100)
Revenue | |
Sales ID | SO portion |
SO1 | 30,000.00 |
SO2 | 372,300.24 |
Total | 402,300.24 |
Team | ||
Sales order | Team | Team manday % |
SO2 | Team D | 3.89 |
SO1 | Team B | 20.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team A | 2.92 |
SO2 | Team A | 2.92 |
SO2 | Team C | 0.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO1 | Team B | 20.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO1 | Team B | 20.00 |
SO1 | Team B | 20.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO1 | Team B | 20.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team B | 1.00 |
SO2 | Team A | 2.92 |
SO2 | Team A | 2.92 |
SO2 | Team D | 3.89 |
SO2 | Team D | 3.89 |
SO2 | Team D | 3.89 |
SO2 | Team D | 3.89 |
SO2 | Team D | 3.89 |
Actual result:
Team A | Team B | Team C | Team D | Column total | |
SO1 | 30,000.00 | 30,000.00 | |||
SO2 | 43,435.03 | 241,995.16 | - | 86,870.06 | 372,300.24 |
Row total | 43,435.03 | 663,795.40 | - | 86,870.06 | 804,600.48 |
Expected result:
Team A | Team B | Team C | Team D | Column total | |
SO1 | 30,000.00 | 30,000.00 | |||
SO2 | 43,435.03 | 241,995.16 | - | 86,870.06 | 372,300.24 |
Row total | 43,435.03 | 271,995.16 | - | 86,870.06 | 402,300.24 |
I have no idea why I got this result.
If you have any suggestion or something for help me, don't hesitate for reply.
Thank you very much.
Solved! Go to Solution.
@ssuzjzuss First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
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
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
@ssuzjzuss First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
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
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8
Thank you so much. You are my hero.