Adding a Prior Year Grand Total Comparison to a Matrix

[particleandwave]

I have a Matrix visual with Row Grand Totals. I would like to add an additional row to the table containing grand total comparisons from the prior year. Is there a way to achieve this?

[amitchandak]

@particleandwave , One way is to replace total with diff using isinscope

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

or you have to consider custom total workaround

refer:https://medium.com/@amitchandak/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e39ca82...