Incorrect Measure Total

Ashish_Mathur, amazing! That's the exact solution that I have been looking for, thank you for your help.

I'm having a similar struggle  where within my datagrid individuals rows are calculating but the total line is wrong.

Stuck thoughts?

Here is my Dax expression:

MTD_PY_Variance_Matrix =
 (
    CALCULATE (
        KPI_Finance_Matrix[MTD_Actuals_Matrix] - KPI_Finance_Matrix[MTD_PY_Actuals],
        KPI_Finance_Matrix[Group] = "Revenue"
    )
)
    + (
        CALCULATE (
            KPI_Finance_Matrix[MTD_Actuals_Matrix] - KPI_Finance_Matrix[MTD_PY_Actuals],
            KPI_Finance_Matrix[Group] = "Gross Margin"
        )
    )
    + (
        CALCULATE (
            KPI_Finance_Matrix[MTD_PY_Actuals] - KPI_Finance_Matrix[MTD_Actuals_Matrix],
            KPI_Finance_Matrix[Group] = "Operating Expenses"
        )
    )

Im at a breaking point, tried all the suggestions from many articles but still struggling with fixing totals.

1. created a measure to return sales last year using the below

VAR = CALCULATE(SUMX(Sales,Sales[revenue local currency]),DATEADD('Calendar'[Date],-1,YEAR))

 

2. Created another measure to return fx rate from the sames for the selected year and month on the slicer

 

VAR B =MIN(Sales[rate])

 

3. convert the local currency revenue to USD

DIVIDE(A,B,0)

Calculation works, but the total is incorrect. I used the below DAX in one measure,

 

REV_USD_LY = 
VAR A = CALCULATE(SUMX(Sales,Sales[revenue local currency]),DATEADD('Calendar'[Date],-1,YEAR)) 
VAR B = CALCULATE(MIN(Sales[rate]),ALL('Calendar'))
VAR div = DIVIDE(A,B,0)

 

If you see the total, it returns sames as revenue local currency last year, can you please help?

Hi,

Please explain the business question and show the expected result.