cumulative Graph with dynamic start value

isThatAFrog — Mon, 22 May 2023 09:43:59 GMT

Hi Guys,

I have a graph that i cant get to filter on the effective date on because the query is created so that it calculates the startdata backwards and adds it the day before the first date, is there a way to keep the values from the first date when applying filter on the effective date
Formula

MoveCalc Cumulative =

CALCULATE([MoveCalc Total],

FILTER(ALLSELECTED('Mobility All'),

'Mobility All'[Effective date] <= MAX('Mobility All'[Effective date])))

Without filter

With filter applied

Maybe with some first date or ALL min value??

Many thanks for any help!

Re: cumulative Graph with dynamic start value

Anonymous — Wed, 24 May 2023 08:09:59 GMT

Hi isThatAFrog ,

I created some data:

Do you mean that in the filtered visual, the value of the current first date is the value of the first date after the filter plus the value of the day before the first date after the filter?

1. Create measure:

Measure = var _date= MINX(ALLSELECTED('Mobility All'),[Effective date]) var _mindate= MAXX( FILTER(ALL('Mobility All'),'Mobility All'[Effective date]<_date),[Effective date]) return SUMX( FILTER(ALLSELECTED('Mobility All'), 'Mobility All'[Effective date]<=MAX('Mobility All'[Effective date])),[MoveCalc Total]) + SUMX( FILTER(ALL('Mobility All'),'Mobility All'[Effective date]=_mindate),[MoveCalc Total])

2. Result:

If it doesn't meet your expectations, can you express your results in the form of pictures, we can better help you

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

topic Re: cumulative Graph with dynamic start value in DAX Commands and Tips

cumulative Graph with dynamic start value

Re: cumulative Graph with dynamic start value