Calculated Measure Filter with only Slicer

[laingm]

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 calculated over the entire time range of the chart. The chart has datetime on the x-axis. When plotting the measure as a value, it appears that the measure is calculated at each time point.

By using the ALL in CALCULATE when calculating the measure, I can get all of the datetimes to be used. The problem is that I also have a slicer that shortens the time window shown on the chart. If I use ALL, the slicer is not taken into account when calculating the mean or std (it still uses every datetime in the table).

Is there a way to have the calculation only use the slicer as a filter (and not the chart axis)?

[v-chuncz-msft]

@laingm,

You may use ALLSELECTED Function to achieve it.

[laingm]

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.

[v-chuncz-msft]

@laingm,

Try to use ALLSELECTED ( Events[DateTime] ).