Forum Discussion

PBInonpro's avatar
PBInonpro
Icon for Helper III rankHelper III
3 years ago
Solved

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

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)   ...
Need Help
Tutorial Requests
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Icon for Community Support rankCommunity Support
3 years ago

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.