Forum Discussion
Helper IIIMatrix 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)
When nothing is selected, I would prefer for the table to be blank.
Sorry for the crude drawing, but as an example:
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.
1 Reply
v-jianboli-msftCommunity Support
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.