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 omg, you made is super complicated and it is very simple things to do, you just need to change the interaction between your center visual with right visual from cross highlight to cross filter.

 

- go to format tab

- click edit interactions

- select center visual

- on right visual, click filter icon instead of cross highlight and that will do it

 

 

I hope this is what you are looking for.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

TheMajesticKing here is the post how it works

 

I would 💖 Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!