Forum Discussion
Solved
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 202...
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 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