Forum Discussion
Adding a Prior Year Grand Total Comparison to a Matrix
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?
1 Reply
- amitchandak
Super User
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
