Soldato
- Joined
- 22 Nov 2007
- Posts
- 4,209
Hi All
I've been learning power bi for an upcoming job and i've made a simple(ish) football model but im a bit confused by the relationships
Here is my data model that i've just amended and now giving correct data for total goals scored by team and total goals scored by player - https://ibb.co/nLYfm3G
This is my how my model was before and it was giving incorrect data for the two counts mentioned above - https://ibb.co/RP2qgqF
I don't get how clubs>fixtures>goalscorers doesn't seem to give correct calculations/data. Shouldn't the clubs table be connected directly to the fixtures?
I've been learning power bi for an upcoming job and i've made a simple(ish) football model but im a bit confused by the relationships
Here is my data model that i've just amended and now giving correct data for total goals scored by team and total goals scored by player - https://ibb.co/nLYfm3G
This is my how my model was before and it was giving incorrect data for the two counts mentioned above - https://ibb.co/RP2qgqF
I don't get how clubs>fixtures>goalscorers doesn't seem to give correct calculations/data. Shouldn't the clubs table be connected directly to the fixtures?
Last edited: