Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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/
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 40 | |
| 30 | |
| 24 |