How to apply custom measure in matrix for a values column in the subtotal row

[j_w]

For example, the subtotal Margin % in the subtotal row should be calculated as 26.58 / 60.48 * 100% = 43.95%, instead of summing the individual Margin % values.

[Ashish_Mathur · Accepted solution]

Hi,

If $ margin and Total revenue are measures (and if they are not, then you should ensure that they are measures), then this simple measure should work for all rows

Margin (%) = divide([$ margin],[Total sales])

Hope this helps.