Column Subtotal Not Correct

Anonymous 

Hi, isnt that your expected outcome? Of the deals greater than $2m...there is a variance of -5.57%... resulting from a -0.77% in Cali, -1.31% in Southeast and so on?

Doing some SUMIFs in Excel seems to validate the measure results. 

To resolve this, you can replace ALLSELECTED() with ALL(). This function removes all filters from the measure context, allowing for correct calculation of subtotals across all dimensions.

Revised Measure:

Metric % Deal GCI Variance =
DIVIDE (
SUM ( 'Split Summary'[Deal GCI] ),
CALCULATE (
SUM ( 'Split Summary'[Deal GCI] ),
ALL ( 'Split Summary' )
)
)
- DIVIDE (
SUM ( 'Split Summary'[Deal GCI (Previous Year)] ),
CALCULATE (
SUM ( 'Split Summary'[Deal GCI (Previous Year)] ),
ALL ( 'Split Summary' )
)
)

Explanation:

ALL( 'Split Summary' 😞 This removes all filters from the Split Summary table, ensuring that the SUM operations are performed across all rows, regardless of the current filter context.
Subtotals: With this modification, the subtotals will now calculate the percent of total deal GCI variance correctly, considering the entire dataset without the influence of row or column filters.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!