Add Row at end of matrix visual showing % of grand total

[Ayush_Kar5]

I want to add an extra row at the end of the matrix visual (similar to grand total row).

Which will be showing the percentage of subtotal row divide by total.

For example in the below image:

I desire the yellow additional row in the Matrix visual of power bi.  (By dividing the pink row (on time units) by blue row (grand total), to find the ontime %)

- One way is I add one more matrix visual and overlap, then group it to make one visual (but that I don't want to do)

- I want to create all the rows in just one matrix visual (Please let me know if it is possible ?)

Please note: the black outlined box in the image has already been achieved in matrix PBI Visual, I just want to add the yellow row in the matrix

Is there any other way in which I can add the yellow row in the Matrix Visual

Please comment, in case more details required.

I will be really grateful for the help!!

 (Dear Super users, Please help me out or please show me the right direction)

@Greg_Deckler , @amitchandak @Ritaf1983 , @ryan_mayu , @lbendlin , @DataInsights 

Thanks a lot in advance.

[parry2k]

I am ok without it 😂 but then you don't want it to be answer for many problems

. 🙏

[parry2k]

@lbendlin Well I wouldn't say not possible. just need to recreate the data to achieve the desired result. I think the link @Greg_Decklershared has some solution, not had a chance to look at it though. 

[Ayush_Kar5]

@parry2k , thanks for giving me hope but please can you elaborate and help me more and share some example, in case you have one?

[lbendlin]

Where I come from we call that "sowing a button to your cheek".

[Greg_Deckler]

@lbendlin That's my DAX special power! Lol!! 😛

[lbendlin]

Not possible.  Use a separate visual or repurpose the row total.  (Don't name it Grand Total, that has a different meaning!)

[Ayush_Kar5]

Thanks.

Please can you explain, repurpose the whole total?

[lbendlin]

In a table visual each measure is calculated twice, once for the rows and once for the row total.  You can use HASONEVALUE to distinguish between these scenarios, and return different results if you want.  For example the row measure can return the sum of a value but the row total can return the average of these sums, instead of the total sum.

In a matrix visual a measure is calculated four times.  Cells, row total, column total, and grand total (in the bottom right corner)

[Greg_Deckler]

@Ayush_Kar5 It's basically a variation of this: The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

[parry2k]

@Ayush_Kar5 you have to basically create an extra row in the table for the total and then do the logic around that.