How to always compare a selected area with two fixed areas?

[Anonymous]

I have a dimension table called 'Dim Gebieden', which contains a key column and a column with area names. The area names column includes all the neighborhoods in my municipality, the municipality itself, and the Netherlands. This table is related to a fact table via the key column.

In my report, I have a slicer with a single selection option, allowing the user to choose a neighborhood from the municipality. This filters the 'Dim Gebieden' table based on the selected neighborhood.

However, what I want to achieve is that the selected neighborhood is always compared with data from the Netherlands and the municipality. If I add an additional slicer that includes the Netherlands and the municipality, multiple neighborhoods can be selected, which is not desired. The goal is to always filter the 'Dim Gebieden' table on the Netherlands, the municipality, and one user-selected neighborhood.

[Anonymous · Accepted solution]

Hi @Anonymous,

Create a measure to include the municipality and the Netherlands itself:

Measure = CALCULATE(MAX('DataTable'[Gebiednaam]),FILTER('DataTable','DataTable'[Gebiednaam] IN {"Nederland","Dijk",SELECTEDVALUE('SlicerTable'[Gebiednaam])}))

Then add the measure to your visual, so that the data can be filtered according to the neighbourhoods you have selected in the slicer, with data for both municipalities and the Netherlands included.

Best regards,

Joyce

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.