Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Table Subtotal

[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 incorre...
Need Help
Show and Tell
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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