Use a Calculated value as a slicer

Hi Simon_G - Create a measure to filter cities based on whether their solar insolation values are higher than the calculated solar insolation needed. 

Below measure i have used for testing with financial sales and profittotal, you can change it to  solar insolation measure values.

CitiesFiltered =

VAR TotalSales = SUMX('financials', financials[Sales])

VAR TotalProfit = [profittotal]

RETURN

    IF(TotalSales >= TotalProfit, 1, 0)

 

In the Filters pane for the map visual, add the CitiesFiltered measure.Set the filter to only include rows where CitiesFiltered is 1.

 

 

 

try the above process and let know. 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!