Forum Discussion
Relationship issue
As a general rule I always hide the column on the "many" side of a 1 to many relationship as any time you have more than fact table in a complicated model using the column from the many side will always cause this sort of data explosion due to the way filters propogate along relationships. From the limited snapshot we can see I think if you only ever use 'List Location'[Location] then everything should work OK.
Note that setting the crossfilter direction on the relationship may at first appear to "solve" this issue. But doing so will negatively impact the performance of the model and with the number of relationships you have in your model I can almost gurantee that adding a bidirectional filter will produce incorrect results.
As a general rule I always hide the column on the "many" side of a 1 to many relationship as any time you have more than fact table in a complicated model using the column from the many side will always cause this sort of data explosion due to the way filters propogate along relationships. From the limited snapshot we can see I think if you only ever use 'List Location'[Location] then everything should work OK.
Note that setting the crossfilter direction on the relationship may at first appear to "solve" this issue. But doing so will negatively impact the performance of the model and with the number of relationships you have in your model I can almost gurantee that adding a bidirectional filter will produce incorrect results.
