matrix sub total - enable freeze pane ability for all table total

[Anonymous]

When I switch from using a regular Table viz, to a Matrix Viz, Totals get harder to work with. I still want the Grand Total Numbers for the entire table to be frozen at the top of the Matrix Vizualization. 

[v-yiruan-msft]

Hi @Anonymous ,

Whether the problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help other members in the community find the solution easily if they face the similar problem with you. Thank you.

Best Regards

Rena

[v-yiruan-msft]

Hi @Anonymous ,

You mean the total value is incorrect when switch Table visual to Matrix visual? Could you please provide some sample data and your expected result(exclude sensitive data)? It will help us to make troubleshoting and provide solution. Thank you.

In addition, hope the following blogs can help you resolve the problem.

Making Sense Of Subtotals Settings In The Power BI Matrix Visual

Subtotals and Grand Totals That Add Up “Correctly”

Wrong Totals Using IF and Values() in Power BI

Best Regards

Rena

[Greg_Deckler]

"Freeze Pane", wasn't that a song by the J Giles Band? 🙂

Take a look at 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 MM3TR: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-...