A way to stop a measure from interacting with a particular slicer

[Anonymous]

Hi all,

I have a measure as follows:

National Average = CALCULATE(

AVERAGE('Cancer Profile'[Value]),

FILTER('Cancer Profile','Cancer Profile'[Area Code]="E92000001")

)

which gives me the average value for that particula area code (England). 

I have a line chart, which displays the values over years for areas in my district, but I want the measure above to show regardless of what area I pick on my slicer as when I chose an area on my drop down, the average line dissapears from the line chart. 
I understand why as it's filtering to show only those values within the chosen area code and the above measure isn't included, but how do I make the average remain?

Any thoughts?

[Anonymous]

Hi

Not sure if i understood correctly, but if you want to remove the filter context for a certain table you can do that with the ALL() function.

Try something like this

National Average = CALCULATE(
AVERAGE('Cancer Profile'[Value]),
FILTER(
ALL('Cancer Profile')
,'Cancer Profile'[Area Code]="E92000001")
)

For further documentation check this microsoft examples, as there are some variations of ALL function that can be usefull to you

https://docs.microsoft.com/en-us/dax/all-function-dax

[negi007]

@Anonymous you can disble interaction between a slicer and a visual using edit interaction feature. see below for help.

[Anonymous]

I don't want the slicer to stop interacting with the visual, I just want the measure to be present on the visual regardless of what the option is selected on the slicer.

For example: 

When no area is selected on the slicer, the above visual shows the national average at the bottom, but when you chose a specific area:

The national average then disappears when an area is chosen, becasue it's obviously just looking at that area. 
I want the national value average to stay on the graph, regardless of what area is chosen so you can compare. 

if that makes sense?