Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

complicate relationship available?

Hi, I want to make some dimension can be filtered based on exist history data table, but I have a problem to creat relationship, the expected relationship is like this: does this kind of rela...
Need Help
Show and Tell
selimovd's avatar
selimovd
Icon for Most Valuable Professional rankMost Valuable Professional
3 years ago

Hey Anonymous ,

 

that wouldn't work as it would allow abiguity.

Sorry for that.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for you answersing, Could I know where is the abiguity this model exists? If I want dim_table2 and dim_table3 can be filtered by dim_table1, and at the same time fact_table can be filtered by both dim_table2 and dim_table3, is there to be an alternative solution? Thank you.

    • v-jingzhang's avatar
      v-jingzhang
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi Anonymous 

       

      You cannot have more than one active relationships between two tables (dim_table_1 and fact_table). You could have a look at Active vs inactive relationship guidance - Power BI. This means one of the relationships in your picture should be an inactive relationship. To use an inactive relationship, you can use USERELATIONSHIP function in DAX expressions. Please refer to Using USERELATIONSHIP in DAX - SQLBI

       

      Best Regards,
      Community Support Team _ Jing
      If this post helps, please Accept it as Solution to help other members find it.