Forum Discussion

svp1000's avatar
svp1000
Frequent Visitor
2 years ago
Solved

Bottom table should only show based on top table selection otherwise I want it to show blank

Hi All,   I have a visual table at the top and visual table at the bottom.   The top table has the ID, Name, etc and when I click on it, I want the bottom table to show the corresponding Review c...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi svp1000 ,

    Based on my testing, please try the following methods:

    1.Create the sample table.

    2.Create the new measure to filter the table.

    IsSelected = IF(ISFILTERED('Table'[ID]), 1, BLANK())

    3.Drag the measure into the bottom table Filters pane.

    4.Drag the comment field into the bottom table. The result is shown below.

     

    Best Regards,

    Wisdom Wu

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

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi svp1000 ,

Based on my testing, please try the following methods:

1.Create the sample table.

2.Create the new measure to filter the table.

IsSelected = IF(ISFILTERED('Table'[ID]), 1, BLANK())

3.Drag the measure into the bottom table Filters pane.

4.Drag the comment field into the bottom table. The result is shown below.

 

Best Regards,

Wisdom Wu

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

 

 

 

 

  • svp1000's avatar
    svp1000
    Frequent Visitor
    2 years ago

    this worked for me! all I had to do was to remove the ID from the bottom table and it works as expected