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

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.