Matrix and Table drill-down (parent:child lists)

[PBInonpro]

Is there an option for a table to only reflect the child list linked to a parent list when a record is selected in a matrix?

Matrix: Parent List (orders)

Table: Child List (order line items)

When nothing is selected, I would prefer for the table to be blank. 

Sorry for the crude drawing, but as an example:

[v-jianboli-msft · Accepted solution]

Hi @PBInonpro ,

Based on your  description, I have created a simple sample:

Please try:

Apply the measrue to the table's visual level filter:

Measure = IF(ISFILTERED('Table'[Parent List])&&MAX('Table'[Parent List])=SELECTEDVALUE('Table'[Parent List]),1)

Best Regards,

Jianbo Li

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