Forum Discussion

bacon6actual's avatar
bacon6actual
Frequent Visitor
10 years ago
Solved

Date Table Relationship to Multiple Fact Tables

I am still learning powerbi and I have trouble understanding the relationship results when dealing with multiple fact tables and one date deminsion. I work at a police department that runs a software...
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
10 years ago

Hi there,

 

You need to set a bidirectional relationships between your tables to correctly slice and dice your data. 

 

Just to give you a heads up, Relationships alway propogate from one to many direction.

Try setting up bidirectional relationships and see the issue persist.

 

Thanks & Regards,

Bhavesh

 

  • bacon6actual's avatar
    bacon6actual
    Frequent Visitor
    10 years ago

    I did this, but it did not help. Ultimately one of the agency relationship becomes inactive. The data is still incorrect. It should match the totals in the single columns to the left. Thanks for the response. 

    • BhaveshPatel's avatar
      BhaveshPatel
      Icon for Super User rankSuper User
      10 years ago

      I am working on to recreate your solution. Meanwhile, if possible, please send us a sample file.

       

       

      Thanks & Regards,

      Bhavesh

      • bacon6actual's avatar
        bacon6actual
        Frequent Visitor
        10 years ago

        I would like to, but unfortunately this is not possible as the data is CJIS protected under FBI regulations. I can only post the problem and perhaps work with someone independently offline if a solution cannot be provided. Thanks for responding. 

    • BhaveshPatel's avatar
      BhaveshPatel
      Icon for Super User rankSuper User
      10 years ago

      Hi there,

       

      Have you set up a correct data types? 

       

      Regards,

      Bhavesh

      • bacon6actual's avatar
        bacon6actual
        Frequent Visitor
        10 years ago

        Yes all data types are set correctly. Its seems pretty staright forward to me, but unlike other BI products its like powerbi does not like to let you filter by more then one deminsion. I do set one relationship to bi-directional the others cause issue and its says that only one filter is allowed. Doesnt make any since to me. I am used to crystal reports and sql.