Forum Discussion
Iteration Troubles
nogstavo I'm not entirely certain what you want here in terms of your results. Here is something that might help:
Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community
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, I'm currently reading your link and trying to understand how it could help me.
Greg_Deckler
I have Sales from SKU 166072 within Cost Center Code, and Total Sales from all SKU's within Cost Center Code (6.248,00).
I expect that when a single sku is selected at a filter level, all the subtotals show the correspondent value from that singular selection.
nogstavo Well, the post is meant to give you complete control over subtotal calculations at any level in a hierarchy within a matrix. Do you have sample data that you could share to recreate this issue as it is very difficult to understand what could be going on here.