Forum Discussion
Issue with values when tables have duplicates
I have a power Bi issue that I cant seem to resolve, i was wondering if anyone could assist? I have 3 tables Results Racecard Import Each table has a relationship via the column [Horse...
Hi there.
First of all, you don't understand the rules of data modeling; that's clear from what you say. Power BI does not allow any other relationship? Well, maybe you should then change the model. I'll tell you more, you MUST change the model if you want to produce comprehensible numbers. If you don't do it, be prepared to face issues you won't even be able to understand.
Second, what you try to describe is not fully understandable. Please note that you are describing something to people who have no idea about what your model is, what it should calculate and what the issue really is....
My advice to you would be to first do some reading about proper data modeling. It's the best piece of advice you can get. Trust me.
Best
D
First of all, you don't understand the rules of data modeling; that's clear from what you say. Power BI does not allow any other relationship? Well, maybe you should then change the model. I'll tell you more, you MUST change the model if you want to produce comprehensible numbers. If you don't do it, be prepared to face issues you won't even be able to understand.
Second, what you try to describe is not fully understandable. Please note that you are describing something to people who have no idea about what your model is, what it should calculate and what the issue really is....
My advice to you would be to first do some reading about proper data modeling. It's the best piece of advice you can get. Trust me.
Best
D