Use the selected row as a filter to the another column on the same table?

[Anonymous]

Hi,

I have a table with all products and its compononents at my company, for example:

FATHER_PRODUCT	SON_COMPONENT
XXX	X-1
XXX	X-2
XXX	X-3
XXX	X-4
X-4	X-41
X-4	X-42
X-4	X-43
X-3	X-31
X-3	X-32
X-3	X-33

The FATHER_PRODUCT column has the name of the product and the SON_COMPONENT column has the name of the componentes used on the product, and as you can see in this example there are some components that are also a FATHER_PRODUCT with other components and so on.

What I am trying to do is when I select a row of this table I would like to go to another page and use the SON_COMPONENT selected as the FATHER_PRODUCT... is it possible?

example: suppose user select the row 4, I want to create a button where the user goes to another page with another table as shown:

I tried several ways, but wasn't able to achieve it yet...

[v-angzheng-msft · Accepted solution]

Hi, @Anonymous 

Steps.
1. Create a copy of the table (Table 2), create the calculation table: Table 2 = Table 1
2. Create a new target page and create a visual with the fields of table 2
3. Drag and drop the fields from the original table (Table 1) into the drill-through section of the target page
4. Create the following measures and filter the items in the filter pane of the target page for measures equal to 1

_selectedSON = 
SELECTEDVALUE('Table'[SON_COMPONENT])

isShow = IF(SELECTEDVALUE('Table 2'[FATHER_PRODUCT])=[_selectedSON],1,0)

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

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

[lbendlin]

Not directly. Drillthrough does not (yet) allow cloumn transitions. You'd have to use a measure on the drillthrough target page to accomplish some of that.