measure calculation not working as intended

[avinrosh]

Hi I have created a measure to calculate cumulative value.

My measure looks something like this

Probabalized = CALCULATE(sum(AllData[Probablised]),filter(AllData, (AllData[Status]="Secured" || AllData[Status]="Pipeline") && ((AllData[Period]>= EOMONTH(TODAY(),-1) && AllData[Period]<= date(2018,12,31)))))

And I get the output like this.

When I modify the measure as follows, with All

Probabalized = CALCULATE(sum(AllData[Probablised]),filter(All(AllData), (AllData[Status]="Secured" || AllData[Status]="Pipeline") && ((AllData[Period]>= EOMONTH(TODAY(),-1) && AllData[Period]<= date(2018,12,31)))))

Whereas I want is cumulutavie sum over the period. Please help me to get me what I am looking for.

[v-jiascu-msft]

Hi @avinrosh,

Could you please tell me if you solved it? Can you share the answer or mark the proper answer as a solution, please?

Best Regards,
Dale

[v-jiascu-msft · Accepted solution]

Hi @avinrosh,

I would suggest you create an independent date table and make some changes to the formula. It should work like below.

Probabalized =
CALCULATE (
    SUM ( AllData[Probablised] ),
    AllData[Status] IN { "Secured", "Pipeline" },
    FILTER (
        ALL ( datetable ),
        datetable[date] >= EOMONTH ( TODAY (), -1 )
            && datetable[date] <= MAX ( datetable[date] )
    )
)

If you share a sample, we can make it more clear.

Best Regards,

Dale