Forum Discussion
Power BI Matrix report
I am a new power bi user. i created a matrix chart which shows three columns of data. 2025, 2026 budget and 2026 actual. I created two measures using dax which is 2026 run rate in one column and 2025 vs 2026 in another. the dax is working well at row level but the bottom of the measure columns it is adding all the percentages rather than dividing the totals of the previous columns. i tried chat gpt to get a solution and all the solutions & dax that i am getting is not helping.
Hi Bryoj316 ,
There are 2 things you can try to get the totals you want.
1. Take a look at custom totals: https://sumproduct.com/blog/power-bi-blog-custom-totals/
2. Crate a new measure with an if statement combined with HASONEVALUE to determine what values to display on a regular row or in the totals row: https://www.youtube.com/watch?v=fBUd0qyjbAY
4 Replies
Hi Bryoj316 ,
There are 2 things you can try to get the totals you want.
1. Take a look at custom totals: https://sumproduct.com/blog/power-bi-blog-custom-totals/
2. Crate a new measure with an if statement combined with HASONEVALUE to determine what values to display on a regular row or in the totals row: https://www.youtube.com/watch?v=fBUd0qyjbAY
Hi,
Please share the download link of the PBI file. Show the problem there very clearly.
Hi Bryoj316
Thank you for submitting your question to the Microsoft Fabric Community Forum, and thanks to djurecic for sharing helpful suggestions.
Could you let us know if the suggested solution resolved your issue? If not, please share any additional details so we can assist further.
Best regards,
Community Support TeamHi Bryoj316
We wanted to follow up as we haven’t received a response yet. Have you had a chance to review the information above? If you have any questions or need further assistance, feel free to reach out.
Thank You.
