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...
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

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.