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

Here's the measure I created but I can't get it to actually filter. I'm likely using it wrong. I imagine I should be using HASONEVALUE here but I'm not sure how to use it:

 

MEASURE = IF(ISCROSSFILTERED(ActiveUsers[Room]), ActiveUsers[ActiveCount], SUMX(FILTER(ActiveUsers, ActiveUsers[Active] > 0, [Active]))

 

Let me again try to explain what I want to do. I want the visual to show all rows with more than 0 active users. However, if I click on a building on the "Map" visual it will filter this visual by "Room" but I want it to show the rooms with 0 active users whenever I click on the building. So clicking on the map visual needs to show all rooms whether or not they have 0 active users.