I have a data in Matrix visual with month wise sales figures and at the end I have row subtotal.
Now when I am adding a measure to show the Sales PY % to the matrix, it is showing for all month (Row) instead of only Grand Total.
I do not need the Sales PY% for each month instead it is only require for Grand Total on Row level.
The measure which I am using for Sales PY% is ProfitPY = CALCULATE([Profit], SAMEPERIODLASTYEAR('Calendar Ultimate'[Date]))
@gauravnarchal , You have to use the suggested way.
I have logged an idea for the same
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
@gauravnarchal - This us Custom Matrix Hiearchy here.
Warning, it's kind of ugly.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
