Audit Matrix sub-totals for troubleshooting?

Question

PBIX File:&nbsp;https://drive.google.com/file/d/1j_4CrUj0fPh0xK6hnO7OZ-uIWkoP5Kdg/view?usp=sharing&nbsp;In the Matrix below, two different [measures] are in the "Values" section of the visual.&nbsp; From an eye test, the subtotals (except for Column 2008) for the Column:[Downside (Graph)] are not directly related to the figures above/associated.&nbsp; For example, in 2011, as shown, the subtotal is over $11 million, whereas the largest datapoint associated is just over $9 million.&nbsp; In contrast, for the Column:[Actual], the figures in the sub-total row do appear to be the average of the above.&nbsp;The&nbsp;Column:[Downside (Graph)] is not averaging.&nbsp; Is there a way to force the programming to result in a summary where the sub-totals are the average of the data sitting above it?&nbsp;&nbsp;

v-xulin-mstf · Accepted Answer

Hi&nbsp;mrothschild,
&nbsp;
Taking the metric '______B - Depreciation Selected' as an example, you can modify the measure to:
______B - Depreciation Selected = 
//DEPRECIATION SELECTED
 var a=
    [zzDepreciation Average - Selected]
       return
       IF( 
                HASONEVALUE('Helivalues Transaction History'[Year of Build]),
                a,
                AVERAGEX('Helivalues Transaction History',a)
            )
You can define the calculation logic for the totals you want in the underlined section.

If you type '0', you can get:

If you still have some question, please don't&nbsp;hesitate to let me known.‌‌
&nbsp;
Best Regards,
Link
&nbsp;
Is that the answer you're looking for? If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution. Really appreciate!

Forum Discussion

Audit Matrix sub-totals for troubleshooting?

2 Replies

Related content

Matrix sub-total calculation?

SUB TOTAL MATRIX ISSUE

Remove totals and sub-totals for some columns in a matrix

Dax measure accumulation no Sub / grand total

Applying theme to Sub Totals of matrix