Measure disappears from a bar chart visual when a slicer is applied

EwelinaP — Thu, 17 Aug 2023 17:18:45 GMT

I have a clustered bar chart visual (below) that shows completion rates based on time of year.

I want the blue column to act as a benchmark and I want it to not respond to any slicers. I want the yellow bar to respond to slicers. To do this, I created a measure for the blue bar that calculates the average and filters for criteria in two separate columns (the figures are pulling correctly). For the yellow bar, I added the appropriate column to the field.

My problem is that whenever I use a slicer, the blue bar goes away completly. How do I fix this problem? My DAX and strucure of my data is below:

DAX FOR BLUE BAR:

Benchmark =

AVERAGEX(

FILTER(

'Start, Mid, End Rate',

'Start, Mid, End Rate'[Organization] = "Benchmark Org" &&

'Start, Mid, End Rate'[Attribute] IN {"Beginning", "Mid-Year", "Year-End"}

'Start, Mid, End Rate'[Value]

)

DATA STRUCTURE:

Any insight is greatly appreciated!

topic Measure disappears from a bar chart visual when a slicer is applied in DAX Commands and Tips

Measure disappears from a bar chart visual when a slicer is applied