Table Subtotal

[Anonymous]

[Edited]

Hi All, sorry for the confusion.

Currently I have this Measure 3 which is able to return the correct value for each country (SG is the sum of Local). However, the grand total is incorrect. It should be 301 + 688 = 989. 

Does anyone know how I can fix the grand total to make it display the correct sum value?

Measure 3 = IF(SELECTEDVALUE(Dim_Country[Country])="Singapore",CALCULATE([Local], ALL(Dim_Country[Country])), [International])

Regards,

BK

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

Try the following formula: 

Measure = SUM('Table'[International]) + SUM('Table'[Local])

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt the first total 989 is wrong.

Try like

International + Local = Sumx(values(Dim_Country[Country]) , IF(Max(Dim_Country[Country])="Singapore", [Local (SG)], [Local + International]))

[Anonymous]

Hi @amitchandak , I have tested out the dax you have provided. It returns the same output as the Measure 3, the grandtotal is showing 301 also. Do you know how I can show the correct grand total instead?

Regards,

BK

[Anonymous]

Hi @amitchandak , you're right that the measure was wrong. I have edited my post and shared the Measure 3 that I'm using. I should be seeing 989 instead of 301 only as all countries have been selected. 

Regards,

BK