Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
Your room count measure needs to be written to ignore filters on the room column. Something like
CALCULATE(countrows(tablename),all(tablename[room]))
Hi @ADB8335 ,
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!
Hi @ADB8335 ,
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!
Your room count measure needs to be written to ignore filters on the room column. Something like
CALCULATE(countrows(tablename),all(tablename[room]))
User | Count |
---|---|
79 | |
75 | |
62 | |
60 | |
47 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |