Forum Discussion
Matrix Sub row totals
Hey everyone!
I have a problem in my matrix that i think you might be able to help me out!
I got a matrix with an instalation and in everyone theres a dropdown with the first 3 years of that instalation. And every year i want to get the initial date and the end date. I got to that part and is working fine, but the probçem is that in the matrix the sub row totals are always getting the highest date, so in one column "Final date" its okay but on the initial date im getting the last first date and not the "first first" date.
Can anyone help me with this? Hopefully i explained it properly.
Thanks in advance
1 Reply
- Greg_Deckler
Community Champion
Duarte_Grego 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/n4TYhF2ARe8Also this: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community