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 IIYeah 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.
Helper IIThat's not what I'm asking. I'm already familiar with the filter button. That's what I used to generate the screenshot. Please read my previous reply entirely. I'm not just asking to filter out the zeros all the time. I want the zeros there when no data is being crossfiltered.