Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a sheet with six tables all pulling from the same data and displaying the same information but used and IF and MATCH function to only grab rows where title = this or that for each table. Each table only consists of dimensions. My issue is that when you select on one of the rows in one table, all of the other tables go blank. I am trying to get each table to ignore any selection from any other table but having only dimensions, I am struggling to do this.
For ignoring filters you can use set analysis and the numer 1 like: sum({1} Measure)
Try creating Data Islands or Alternate States , that shall help