Forum Discussion
Helper IIHow to make an interaction ignore a visualization-level filter
I got it!
Active Users = if(ISFILTERED(Table1[Building]), IF(CALCULATE(SUM(Table1[Active])) = BLANK(), CALCULATE(0, ALL(Table2[Room])), CALCULATE(SUM(Table1[Active]))), SUMX(FILTER(Table1, Table1[Active] > BLANK()),Table1[ActiveUserWithZero]))
Helper IIdaily bump
Super UserTheMajesticKing can you send the pbix file. Remove any sensitive information before sharing it.
- TheMajesticKing
Here's a link to the sample file
https://drive.google.com/file/d/1MEZAb7WoUGLUf-hjWC54T8XpF0HK46GK/view?usp=sharing
- parry2k
- TheMajesticKing
Yeah it's difficult to explain. Maybe I'll try to explain it in long form.
The visual that I want to manipulate is the bar graph (Active Staff By Room) on the right side of the report.
As you can see in your screenshot, there are rooms listed with zero active users. I don't want to see those rooms unless someone clicks on a building in the pie chart. When I click on a building in the pie chart (Active by Building) visual I want the Bar chart to show all of the rooms in that building regardless of whether or not it has 0 active users.
In other words I want to make it so the "Active Staff By Room" visual filters out the rooms with no active users when there is no active crossfiltering but then I want it to "unfilter" whenver a building is clicked in the "Active By Building Visual". I'll attach two screen shots to further explain what I want to see.