Grand total not showing correct total

[Sagejah9]

Hi. I am trying to show sales for different countries for a particular year and period. However the measure I created to sum isn't showing the correct total at the grand total line. 

Sales = switch(true(), country = "USA", calculate(sum(sales table[sales_amount]), channel = "Store"), calculate(sum(sales table[sales_amount]), channel <> "Store"))

[v-easonf-msft · Accepted solution]

Hi, @Sagejah9 

Please try formula as below:

Sales =
VAR a =
    SUM ( 'sales table'[sales_amount] )
VAR b =
    SUM ( 'sales table'[sales_amount] )
RETURN
    SWITCH (
        TRUE (),
        SUM ( 'sales table'[country] ) = "USA", a,
        channel = "Store", b,
        channel <> "Store"
    )

If it doesn't work, please share some relevant screenshots for further research.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@Sagejah9 , try like

Sales = calculate(sum(sales table[sales_amount]), channel = "Store", country = "USA") + calculate(sum(sales table[sales_amount]), channel <> "Store", country <> "USA")

Use the filter in calculate, if needed

http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/