Problem with filtering of visual.

[CallumMurfet]

Hello, I have a problem around filtering. I would like to filter in the city column one specific city , but then have the city average automatically appear in the visual as well (without needing to select it on the filter), where the city average of core is included if the city that is selected is defined as core, and show the city average of key when a key city is selected. 

Any help would be really appreciated.

[tex628]

Hi @CallumMurfet ,

Looks like you need a measure along the lines of this:

Measure =
VAR CoreKey = SELECTEDVALUE(Table[Core-Key])
Return
Calculate( 
[The average value you need] , 
ALL('Table'), 
'Table'[City] = "City Average" ,
'Table'[Core-Key] = CoreKey
)

Give it a try and let me know how it goes, 

Br,
J