Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I wish to only display the numerical total and conceal the "Text Total" at the bottom.
Even though the total appears to be incorrect, is there anyone who can assist me in figuring out the issue?
I would like to have the
It would be helpful to have the Subtotal text removed/hidden from matrix table view.
Hello @Anonymous ,
You could refer to this video which will show you how to remove the totals you don't want to show
https://www.youtube.com/watch?v=ocbpz2Z_tr8&t=113s
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Proud to be a Super User! | |
@Anonymous , You can use isinscope to do that
If(isinscope(table[TeamName]) , [Sum Measure], [Current Measure])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!