Forum Discussion
Building Custom Keys for Data Model
- 1 year ago
Hello, Anonymous , the dimension part, yes, that's kinda the nature of it when you don't use Both cross filter function, which you shouldn'T really.
You can have workaround for that, that you create measure that checks what is filtered in the Fact table and then you apply this measure as filter for your dimension slicers.
Anonymous any chance you could send some sample data or sample file (via onedrive)?
Yeah, give me a minute. One more thing, the dimension table does filter out the fact table. Such as, if i want to filter market through dimension table, it does filter it for the fact table but not for other dimension tables.
- vojtechsima1 year agoSuper User
Hello, Anonymous , the dimension part, yes, that's kinda the nature of it when you don't use Both cross filter function, which you shouldn'T really.
You can have workaround for that, that you create measure that checks what is filtered in the Fact table and then you apply this measure as filter for your dimension slicers.