Forum Discussion
Calculated Measure Filter with only Slicer
I am trying to plot a constant horizontal line on my chart that is the value of a measure (calculated as mean(x) + std(x)). The problem I am having is that I want the mean(x) and std(x) to be calcula...
This does not appear to be working for me:
The calculated value (0.48) is the value I want the red line on the chart to be for the entire plot. Instead, the chart is recalulating the value at each time point on the plot. I want it to be static (horizontal) based on the time slicer for the entire page.
The calculation I am using is;
DIVIDE(CALCULATE(SUM(Events[Event Occurrences]), ALLSELECTED(CALENDAR[DateTime])),
24. * CALCULATE(MAX(Events[DateTime])-MIN(Events[DateTime]), ALLSELECTED(CALENDAR[DateTime])) * CALCULATE(AVERAGE(Performance[Run %]), ALLSELECTED(CALENDAR[DateTime]))
)I have tried ALLSELECTED, but it has the same result.
