Forum Discussion
Advocate IVBi-directional filter on conformed dimension
Hi all,
I have a Tabular model in which a dimension has a relationship to 2 fact tables. I would like to use this dimension as a slicer in my Power BI report, and only show values for which data exists in either/both of these fact tables, as well as to have the data in that dimension filtered when the fact table is sliced by another dimension.
Before bringing in the second fact table, I had a bi-directional filter between the dimension and the fact, and the data filtered just fine in the slicer. However, when I tried creating the relationship between the same dimension and the second fact table, it wouldn't let me apply the bi-directional filter due to ambiguity.
So now I have this one-way filter direction between dim-Fact1 and dim-Fact2, and the issue is that all the values from the dimension appear in the slicer. Is there a way to make this work? In the Multidimensional world this wasn't an issue.
Thanks in advance!
Victor
6 Replies
v-qiuyu-msftCommunity Support
Hi vrocca,
How did you connect to tabular model, Import mode or Live connection? Where did you create the bi-directional relationship and error threw out? On SSAS side or Desktop?
If it's in SSAS project, please take a look at ferzfeld's suggestion in this thread: Error message: Excel allows only one filtering path between tables in a data model.
Best Regards,
Qiuyun Yu- vrocca
Hi v-qiuyu-msft,
I connect to the Tabular model via Live connection. I'm trying to create the bi-directional relationship in SSAS, and that's where I'm getting the error. I tried adding the relationship by using the method suggested in the post you mentioned, but when I try to deploy or open the model I get a similar error about amiguity so I'm unable to add it.
Hey vrocca, usually the ambiguity error is due to multiple possible filter paths. Is there anything else connected to your dimension? Could you post a screenshot of the data model relationships?
