cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Gutenvirt Frequent Visitor
Frequent Visitor

Filter based on another column's value from an associated sclicer selection.

Hello,

 

I have a table of site names and site types.  If a user selects one of the site names in a slicer, how I can show all other site names that have the same site type (based on the slicer selection)?

 

I.e.

 

Site_Name    Site_Type

Site A            1

Site B            1

Site C            2

Site D            3

Site E            1

 

User selects 'Site A' and a table populates with 'Site A', 'Site B', and 'Site E'

 

Thanks!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Filter based on another column's value from an associated sclicer selection.

Hi @Gutenvirt,

 

In this scenario, you should replicate the original table. As a result, there are two tables (In my test, test1 and test2) containing same columns, [Site Name] and [Site Type].

 

Create a measure like below

 

Site Type measure =
CALCULATE (
    LASTNONBLANK ( test1[Site Type], 1 ),
    FILTER ( 'test1', 'test1'[Site Type] = MAX ( test2[Site Type] ) )
)

Add 'test2'[Site Name] into slicer and add 'test1'[Site Name]and measure [Site Type measure] into table visual.
1.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Filter based on another column's value from an associated sclicer selection.

Hi @Gutenvirt,

 

In this scenario, you should replicate the original table. As a result, there are two tables (In my test, test1 and test2) containing same columns, [Site Name] and [Site Type].

 

Create a measure like below

 

Site Type measure =
CALCULATE (
    LASTNONBLANK ( test1[Site Type], 1 ),
    FILTER ( 'test1', 'test1'[Site Type] = MAX ( test2[Site Type] ) )
)

Add 'test2'[Site Name] into slicer and add 'test1'[Site Name]and measure [Site Type measure] into table visual.
1.PNG

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.