Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
SDittmannFleet
Advocate IV
Advocate IV

BUG: Matrix row grand total not working as expected

I have a matrix visual where the two value columns are both measures. The measure in the right-most column returns a sum, the other a count. I would expect there to be row grand totals in the right most column in every row, but there're not there, with one or two exceptions (see screenshots). At first I thought that it's because the other rows have counts of > 1, but as you can see in the screenshots, that doesn't matter. Can this be fixed, or should I open a ticket? Row totals and subtotals are turned on.

SDittmannFleet_1-1703083972617.png

 

SDittmannFleet_0-1703083782730.png

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @SDittmannFleet 

Please refer to the linked videos :

https://www.youtube.com/watch?v=eoT-jPzV3Wk&t=4s

https://www.youtube.com/watch?v=MFctN7xdzfQ&t=51s

If it doesn't help 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @SDittmannFleet 

Please refer to the linked videos :

https://www.youtube.com/watch?v=eoT-jPzV3Wk&t=4s

https://www.youtube.com/watch?v=MFctN7xdzfQ&t=51s

If it doesn't help 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.