REMOVEFILTERS Not working with measure in VAR

[Anonymous]

Hi everyone,

I'm using REMOVEFILTERS to calculate overall Customer Sales, based on staff_id.
The following works perfectly:

Total Sales =

VAR TotalSales =

CALCULATE(

    [Customer Sales],

    REMOVEFILTERS(

        'Dim Employees'[staff_id]

    )

)

RETURN

TotalSales

But if I add the same Customer Sales' measure to a variable and then use that variable in CALCULATE instead of the measure, it does not work. It returns Customer Sales for each staff_id, as if REMOVEFILTERS didn't exist.

Total Sales =

VAR Sales = [Customer Sales]

VAR TotalSales =

CALCULATE(

    Sales,

    REMOVEFILTERS(

        'Dim Employees'[staff_id]

    )

)

RETURN

TotalSales

If a the variable is just storing the Customer Sales measure's result, shouldn't the output be the same?
Does anyone know why is this happening?

Thank you!

[Greg_Deckler · Accepted solution]

@Anonymous Yeah, so variables aren't variable in DAX. Once a "variable" is calculated, that's it, the value for the variable remains static. So, what you are doing won't work in DAX.

[Anonymous]

Got it. 

Thank you!