Forum Discussion
Solved
How to make an interaction ignore a visualization-level filter
I'm having a hard time trying to figure out how to explain what I'm trying to do but here goes: I have two visuals. A Campus "Map" visual and a "Room" visual. The Map visual shows a bunch of buildin...
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]))
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.
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]))