Column sub-total not equal to the sum of the values in the column

[Anonymous]

Hi,

See below the measure for 'Voluntary Contribution'. The values in the column highlighted green are coming from the 'CG Con Cont' dataset and those that are yellow come from the 'Capital Guardians' dataset. 

However, the total $17463 (red box) seems to only sum those values that are green and ignores the value in yellow. As the real aggregate total of the column should be $24401.

Can someone advise how i should change my measure?

[Anonymous · Accepted solution]

HI @Anonymous,

It seems like a common issue that appears when measure expression calculate with multiple aggregations, you can refer to the Greg’s blog to know how to handle this scenario:

Measure Totals, The Final Word 

Regards,

Xiaoxin Sheng

[HotChilli]

It's a DAX totals problem.  There's plenty of information available on this.  Search the forum.