Over time, the accumulated measure in DAX is losing values

[marcus_pinheiro]

I have defined the following measure in DAX:

_3_Cotas = CALCULATE(([value1] + [value2]), ALL('Calendar'[Date]), 'Calendar'[Date] <= MAX('Calendar'[Date]))

Despite there being no negative values in the entire database, the measure occasionally shows decreasing points. It's worth noting that both 'value1' and 'value2' are integer values derived from other measures.

[Anonymous]

Hi @marcus_pinheiro ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Dangar332]

hi, @marcus_pinheiro 

_3_Cotas = CALCULATE(([value1] + [value2]), ALL('Calendar'[Date]), 'Calendar'[Date] <= MAX('Calendar'[Date]))

here first you remove filter context of calender[date] and then you compare with same filter context of Calendar'[Date] <= MAX('Calendar'[Date]). it's might problem here

so you want to ignore filter of  calender[date]  or  want to remove filter context of calender[date].

if you want to running sum of ([value1] + [value2] then it work using blow code 

_3_Cotas = CALCULATE(([value1] + [value2]), 'Calendar'[Date] <= MAX('Calendar'[Date]))

[marcus_pinheiro]

This doesn't work.