Forum Discussion

vrocca's avatar
vrocca
Icon for Advocate IV rankAdvocate IV
9 years ago

Bi-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 ...
Need Help
vrocca's avatar
vrocca
Icon for Advocate IV rankAdvocate IV
9 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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?

    • vrocca's avatar
      vrocca
      Icon for Advocate IV rankAdvocate IV
      9 years ago

      Hi Anonymous, yes, my dimension is a conformed dimension that is linked to another fact table.

       

      Below is a basic sample of the model I'm working with. I have 2 dimensions (say Date and Product) and 2 fact tables (say Sales and Returns).

       

      In the first screenshot you can see that both dimensions have relationships to both fact tables in a 1-many format. If I try to make the filter in any of those relationships to be bi-directional, I get an error. The only way I can add it is if I delete or make inactive one of the relationships (screenshot 2).

       

      Ideally I would like to have these dimensions be filtered by what's in the fact tables, so that when a user views the report and wants to see Sales/Returns for a Product, they only see a list of Products (in a report Slicer) for which there is data (in either of the fact tables)

       

      Screenshot 1

       

       

      Screenshot 2

      • vrocca's avatar
        vrocca
        Icon for Advocate IV rankAdvocate IV
        9 years ago

        Similar model in Power BI Desktop with a data import. I'm able to create 1 bi-directional filter, but unable to add it to any of the other relationships.