Cumulative and Filters

[Anonymous]

Hello everyone,

i have following situation: i have a calculate measurement with some parameter, here for expample

Var Total = CALCULATE(SUM(FactIs[balance]),FILTER(ALLSELECTED(FactIs),FactIs[aggregationID]=1))

On this table with this measurement have several filter an impact, one of them is  period (period is equal to year & „0“ & period, in wich period is 01 to 15, e.g. 2020001-2020015). Table FactIs is connected with table DimPeriod (across PeriodUID)

Well, now is my tasc, to calculate „cumulative Total“…

_____

1. I can´t reset only one filter for my calculation, right?
   2. To reset all filter is not helpful

_____
well, what is the solution for calculation?

My idea was….
a. var x1 = value(selectedvalue (DimPeriod[PeriodUID]))           // to find out witch period is selected

Var Total = CALCULATE(SUM(FactIs[balance]),FILTER(ALLSELECTED(FactIs),FactIs[aggregationID]=1), FactIst[PeriodUID]<=X1)

Well… i don´t get cumulative result, only result for one period

_____
Q: is there realy no posibility to reset only one filter?
Is there only one solution with  recoding of all status of all filter? And then go over All() and set the filter...
____
Well, i have here another solution with 2 extra tables, interaction, and measurment... but at leaset, i want to make things easy and stay with only formula.

TY for your ideas

[amitchandak]

@Anonymous , Try cumulative like

CALCULATE(SUM(FactIs[balance]),FILTER(ALLSELECTED(FactIs),FactIs[aggregationID]=1 && FactIst[PeriodUID]<=max(DimPeriod[PeriodUID]))

if you want to reset the cumulative for say each Region the try like

CALCULATE(SUM(FactIs[balance]),FILTER(ALLSELECTED(FactIs),FactIs[aggregationID]=1 && FactIst[PeriodUID]<=max(DimPeriod[PeriodUID])
&& FactIst[Region]<=max(DimPeriod[Region])) )