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 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.
Super UserTheMajesticKing if your screenshot is showing zero room, what we are missing. I'm surely missing the point here.
- TheMajesticKing
I really appreciate your help but it seems that you're not understanding what I need. I've explained it 5 different ways with screenshots and everything so I'm not sure what else to do. I'd love for us to get this sorted out. If you have some time, please read back through all of my previous replies and you might get a better idea of what i want. The screenshots that I attached are two different scenarios. In order to generate those screenshots I had to manually filter and unfilter the zeros from the bar chart. I want this to happen automatically. I told you it was hard to explain. It's not a simple thing. lol
- parry2k
TheMajesticKing nothing is simple until it sorted out. let's book a time over zoom and discuss it thru screen sharing if you are open to it.
- TheMajesticKing
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]))