Forum Discussion
Total not coming correct in matrix view
The Total is not coming correct. All the columns are coming from different tables. A quick help is needed here.
Here is my measure.
4 Replies
v-jianboli-msftCommunity Support
Hi redsailbi ,
What does your raw data look like? Could you please provide the information about your matrix visual?
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario?
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jianboli-msft if you can see the above image i.e matrix visual where the lowest tickets numbers are are showing 1.85 & 0.15. if we addd 1.85+0.15= 2(expected output) at all the levels in the visual here are the levels TeamName-->OwnerName-->WINumber-->TicketNumber.
This is how model looks like.- Greg_Deckler
Community Champion
redsailbi 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/n4TYhF2ARe8Greg_Deckler i tried to use your approach but still the total is coming incorrect.
