Interactive Visuals

[Anonymous]

My situation is more complex than this, but I'll keep it simple.  I have 2 visuals in a report, show below in the screen shot (just using Excel as an example).  Obviously, the standard behavior would be that if I click on a row in the top table that the bottom table would show the Level I selected and a count of 1.  Is it possible to set the interactions so that the bottom table is only filtered by the Level and not the Room?  I want to be able to click on any of the records for Level = Main in the top table and have the bottom table show Level = Main and Room Count  = 3.

Thanks for the help.

[MattAllington · Accepted solution]

Your room count measure needs to be written to ignore filters on the room column. Something like

CALCULATE(countrows(tablename),all(tablename[room]))

[Anonymous · Accepted solution]

Hi @Anonymous ,

Thanks for the reply from MattAllington .

First, create a measure to calculate the Count of each Level:

Room Count = CALCULATE(COUNTROWS('Room'),ALLEXCEPT(Room,'Room'[Level]))

The page effect at this time is as follows:

Select the table above, select the Format tab, turn on Edit interactions, and make sure that the tables below are affected by the table above, that is, make sure they have interactions turned on.

Make sure they have interactions enabled and then turn off Edit interactions.

At this point, select any record in the top table that has Level = Main, and the bottom table shows Level = Main and Room Count = 3.

The final page effect is as follows:

pbix file is attached.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[MattAllington · Accepted solution]

Your room count measure needs to be written to ignore filters on the room column. Something like

CALCULATE(countrows(tablename),all(tablename[room]))