How to write DAX to calculate average group value excluding slicer selection

[Anonymous]

I have line chart, this line chart as value on the y axis and date on the x axis and a slicer that contains different categories (when a category is selected, it dynamically affect the chart and it is a single selection).

I want to write a dax expression that will be placed on the chart; the dax should get the average of the value of all categories in the slicer but exclude the selection made on the slicer.

For example, the category slicer has Planned, Not Planned, Forecast and Past Planned, hence when Planned is selected in the slicer then calculate the average value of Not Planned, Forecast and Past Planned excluding Planned that was selected in the slicer. This will dynamically recalculate when selecting another value in the slicer hence what is selected is excluded from the average calculate.

How can I achieve this using dax?

[Greg_Deckler]

@Anonymous You want Inverse Aggregator: Inverse Aggregator - Microsoft Power BI Community