topic Re: Over time, the accumulated measure in DAX is losing values in DAX Commands and Tips

Over time, the accumulated measure in DAX is losing values

marcus_pinheiro — Thu, 26 Oct 2023 18:07:21 GMT

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.

Re: Over time, the accumulated measure in DAX is losing values

Dangar332 — Thu, 26 Oct 2023 18:56:07 GMT

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]))

Re: Over time, the accumulated measure in DAX is losing values

marcus_pinheiro — Fri, 27 Oct 2023 11:14:18 GMT

This doesn't work.

Re: Over time, the accumulated measure in DAX is losing values

Anonymous — Tue, 31 Oct 2023 07:10:36 GMT

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