Setting value of a specific column

[Niels_T]

Hello,

I have this following measure:

Total Last Month Quantity (base) =

CALCULATE(SUM(Returns[Quantity (base)]),ALL('Calendar'),'Calendar'[CurMonthOffset])

But I would like to have it something like this:

Total Last Month Quantity (base) =

CALCULATE(SUM(Returns[Quantity (base)]),ALL('Calendar'), WHERE 'Calendar'[CurMonthOffset] == -1)

How can I write my DAX measure like this?

[amitchandak · Accepted solution]

@Niels_T , Try like

CALCULATE(SUM(Returns[Quantity (base)]),Filter(ALL('Calendar'), 'Calendar'[CurMonthOffset] = -1) )