Forum Discussion

mgrayTCB's avatar
mgrayTCB
Helper IV
4 years ago
Solved

Dim Table will filter fact table by any column except one

I have a simple dimTable that filters a fact table. I can use any column in the dim table and get the correct results but there is one field in the dim table that when used in a slicer does nothing. ...
  • bcdobbs's avatar
    4 years ago

    That's very strange behaviour.

    A few thoughts:

    1) First thing I'd check is the definitions of the measures. Make sure they're not removing that field from the filter context for some reason (look for ALL, REMOVEFILTERS etc).

     

    2) Has the model been refreshed (either full or a recalculate via tabular editor).