Forum Discussion
cumulative Graph with dynamic start value
- Anonymous3 years ago
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
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