Power bi data model

22 Nov 2007
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?
Last edited:
Top Bottom