Forum Discussion
Building Custom Keys for Data Model
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.
Hi, Anonymous ,
I would check that you did use correct column to create the connection (maybe it's silly but that's usually the issue). Then you can check that you have the same data types of those columns and that you have actually some matching values and you use Dimension for the filtering.
So, as an example I will take the addresses dimension which has ZIP(int) and address(text). I used the same columns with the same type to merge then. The merge worked fine and its giving me the right values in the Fact table. I also did the same for Market, region, submarket (text) and got the values but they dont seem to work on the reports page.
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.