Matrix visual - Calculated Measure showing on all rows of table in report

[gauravnarchal]

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]))

[amitchandak]

@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

[Greg_Deckler]

@gauravnarchal  - This us Custom Matrix Hiearchy here. 

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

Warning, it's kind of ugly.