Forum Discussion
Filter Table Without Including the Column You are Filtering On
Hi, I have a fact table: AccountType 1 A 2 B 3 B 4 C 2 C 1 C 1 A 3 A 1 D 4 C With an Account dimension: AccountName 1 W 2 X 3 Y 4 Z...
It sounds like you want bi-directional filtering on the relationship between the tables (I'm assuming you have a one-to-many relationship from Dimension[Account] 1 -->-- * Fact[Account] ).
Bi-directional relationships can cause relationship ambiguities though so it may be better to do the cross-filtering within whatever measures you are using.
It sounds like you want bi-directional filtering on the relationship between the tables (I'm assuming you have a one-to-many relationship from Dimension[Account] 1 -->-- * Fact[Account] ).
Bi-directional relationships can cause relationship ambiguities though so it may be better to do the cross-filtering within whatever measures you are using.