Forum Discussion

TheMajesticKing's avatar
TheMajesticKing
Icon for Helper II rankHelper II
6 years ago
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...
Need Help
  • TheMajesticKing's avatar
    TheMajesticKing
    6 years ago

    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]))
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

TheMajesticKing if your screenshot is showing zero room, what we are missing. I'm surely missing the point here. 

TheMajesticKing's avatar
TheMajesticKing
Icon for Helper II rankHelper II
6 years ago

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's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
    TheMajesticKing
    Icon for Helper II rankHelper II
    6 years ago

    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]))