Get visual filtered by a different context when clicking on a map visual value(dot)

[ctiago]

Hi,

I'm new to PBI and I have (amongst other columns) the following data of interest about homes:

price	coordinate_x	coordinate_y	postal_code
150000	53.37876129	-2.970038891	CO1 1TG
132000	53.37855093	-2.9604669	CO1 1TG
199240	53.41553497	-2.988910913	LS11 9AH
139950	53.3961525	-2.979218006	M34 3QS
80000	53.41555023	-2.988904118	L11 9AH

I'm using a (Bing) Map visual whose values are given by the latitude (x) and longitude (y) coordinates.

Goal:

I also have a Gauge visual and my desired output is when clicking in one of the map values/dots, have the Gauge set its maximum value to the maximum price of the postal code associated with that house (and its value being the price of the selected home).

Ex: Using the data shown above, If I click on the home priced at 132k, I'd like the Gauge to have 132k as the value and 150k as the maximum value (which is the max price of that postal code).

What I tried:
My attempt was to create a measure to get the maximum of price and exclude all filters from columns other than postal_code.

price_max =
CALCULATE (
    MAX ( 'public home_liverpool_cleaned'[price] ),
    ALLEXCEPT (
        'public home_liverpool_cleaned',
        'public home_liverpool_cleaned'[postal_code]
    )
)

The charts I have seem to respect it, but when I click on a Bing Map value, the maximum value of the Gauge is set to the maximum value of that set of coordinates, rather than the postal code (using the example I gave above, it would just show 132k as both the value and the maximum value). I've also tried adding a postal code filter to the map visual and playing around with the measure formula but to no avail.

How can I achieve this?

Thank you for your time.

[isjoycewang · Accepted solution]

Hi @ctiago ,

I create a dummy file for your reference here.

Please apply below measure to the Max Value of your gauge chart.

price_max = 
VAR _postal = SELECTEDVALUE('Table'[postal_code])
RETURN
IF( _postal <>"", CALCULATE( MAX('Table'[price]), FILTER(ALL('Table'), 'Table'[postal_code] = _postal)), MAX('Table'[price]))

Best Regards,

Joyce