Filter a table based on an associated value from a slicer

[Froznsolid]

Hello all,

I'm quite stuck trying to figure this out. I have a table with information reated to a set of addresses and my goal is to:

• Pick a single address from a slicer
• Find the associated neigborhood 
• Have that asssocaited neighborhood filter a table down to all other addresses in the neighborhood.

I have tried creating a measure and using the measure to filter a table, but it is throwing an error. Below is my attemp and what I whould like as an outcome. Thanks for any help the community can provide!

Attempt

Measure:

SelectedNeighborhood =

CALCULATE(

   MAX(Table[Neighborhood]),

  Table[Address]= SELECTEDVALUE(Table[Address])

)

Filtered Table:

FilteredTable = FILTER(Table, Table[Neighborhood] in [SelectedNeighborhood])

Desired Results

Choose address from Slicer:

Filter the below table to only addresses in the same neighborhood

Address	Neighborhood	Baths	Beds
1015 Fashion	x	2	4
1016 Fashion	x	3	3
1111 Duke	y	2	2
1112 Duke	z	6	6

Final Result

Address	Neighborhood	Baths	Beds
1015 Fashion	x	2	4
1016 Fashion	x	3	3

Thanks!

[grazitti_sapna]

Hi @Froznsolid 

To achieve your desired outcome in Power BI, you can use a combination of a slicer, measures, and a visual-level filter. Here's an example of how you can accomplish this:

Create a slicer visual for the "Address" column to allow selecting single adresss

Create a measure to determine the selected neighborhood based on the chosen address:

SelectedNeighborhood = VAR SelectedAddress = SELECTEDVALUE(Table[Address]) RETURN CALCULATE( MAX(Table[Neighborhood]), Table[Address] = SelectedAddress )

Now select the table visual and go to filter pane on the right side 

Add the filter for the ‘neighborhood’ column.

In filter setting select ‘basic filtering’ and choose ‘is equal to’ as the operator 

And in the value field enter [selectedNeighborhood]

By following steps, selecting address from the slicer will update the 'selectedNeighborhood' measure accordingly.

Thank you 

Hope this will help.