Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Certain measures override Slicing

I have a data table (table 1), where every row of data has a LocationID in the LocationID column.

There's a separate table (table 2), that contains a summarised column of LocationIDs and some supporting data for those IDs.

The relationship is setup in such a way, so that if I slice by the LocationID of table 2, visuals that reference table 1 slice accordingly.

Nothing suprising there and this works well.

 

HOWEVER

 

On a Matrix visual, if I introduce certain measures into the Values field, then it seems to over ride the slicing, and I'll get all Locations in my Matrix column.

All other values continue to conform to the slice.

If I slice by LocationID, but use the column from table 1 (the table that also holds all of the data I'm slicing) then I don't get this issue.

I can't see any pattern in what measures do and don't exhibit this behaviour. 

 

Any idea what could be going on?

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hey Anonymous

       

      I'm pretty sure it's a relationship issue.

       

      Changing the visuals to use the Location column from Table2 fixes the issue, but breaks a lot of the other relationships, so I believe what I'm experiencing is an artefact of the intertable relationships.

       

      Hopefully setting them up correctly will sort this out.