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.

     

     

     

     

amitchandak's avatar
amitchandak
Super User
2 years ago

svp1000 , You can create a measure using isfiltered on group by(Non Sumamrized column) and use that as visual level filter for second table

if(isfiltered (Table[Brand]), [Measure], blank())

 

Use in visual filter on the second table and check that is not blank

 

Refer video from Guyinacube

https://www.youtube.com/watch?v=sXn-QZqLD-8

svp1000's avatar
svp1000
Frequent Visitor
2 years ago

amitchandak  - when i create such a measure, it doesn't turn blank for all the non selected rows and is showing up as the ID for that particular row, and so is still showing up all the rows in the bottom table.

 

basically the top table is aggregated already on amount and other fields. is this a problem?