Forum Discussion
Deviation from Baseline Value
Dear all I am looking for a measure which can deliver a visualisation, where I can see the deviation from a dynamically set baseline date. This baseline value is the number where all subsequent c...
I see the problem you need to all(table) to find the actual minimum date, to correct that please change the dax to the following.
Measure = VAR _BaseValue = CALCULATE(SUM([Value]),FILTER('Table',[Date]=CALCULATE(MIN([Date]),ALL('Table')))) VAR _CurrentValue = Sum(Value) Return _CurrentValue - _BaseValue
Paul Zheng _ Community Support Team
If this post helps, then consider Accept it as the solution to help other members find it faster.
This time, the difference is always 0.
I see the problem you need to all(table) to find the actual minimum date, to correct that please change the dax to the following.
Measure =
VAR _BaseValue = CALCULATE(SUM([Value]),FILTER('Table',[Date]=CALCULATE(MIN([Date]),ALL('Table'))))
VAR _CurrentValue = Sum(Value)
Return _CurrentValue - _BaseValue
Paul Zheng _ Community Support Team
If this post helps, then consider Accept it as the solution to help other members find it faster.