Forum Discussion

MattRasmussen's avatar
MattRasmussen
Helper I
4 years ago
Solved

Data model relationship creates cartesian product

I am trying to get the total number of hours worked on projects by departement.  Multiple departments can work on the same project so there are many examples of the project being listed for each depa...
Need Help
  • MattRasmussen's avatar
    MattRasmussen
    4 years ago

    Our data model is separate from the reports and housed on the Power BI Service so I prepared a file from scratch to share.  However, the report worked as intended!  So I deleted all of the relationships in the data model, saved the pbix file, recreated the relationships, then opened the report and found it worked right.

     

    I don't understand why it didn't work correctly to begin with since the relationships were recreated with the same definitions but I'll take the final outcome.  I guess the resolution is to delete the relationships and try them again.

MattRasmussen's avatar
MattRasmussen
Helper I
4 years ago

As proof that the relationship I defined works, I exported my two tables to Access, then in Access I joined the tables, used the query wizard to make the same query in my screenshot above, and it gave me the results I wanted in less than 10 minutes.

Are there other settings in Power BI that I'm not aware of that are causing my query to show the wrong amounts?  (I've only been using it for six months.)  Thanks to anyone who can shed some light on this.