Is my data model ok?

[Wishmaster91]

Hi All

I am trying to calculate each clubs totao goals scored but i am having some difficulty. 

Here is my a link to my data model 

https://ibb.co/RP2qgqF

A simple dax formula like below does not give the right result so i am confused.

Top scorer = COUNT(Goalscorers[GoalId])

[Wishmaster91]

Still having trouble, is it possible to upload my power bi file? 

[Idrissshatila]

Hello @Wishmaster91 ,

Yes you could put it on google drive and share it here.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Wishmaster91]

Here you go.

https://drive.google.com/drive/folders/1zcE3tnmAbmKKD-muyTg_o-gQGCCB-Tv5?usp=drive_link

Questions

1) do you think this data model is ok?

2) On report view, team goals and player goals are giving accurate data but fixtures does not. I assume this is because there is no direct link between fixtures and clubs and if you connect those tables you will get an error.  Is there any way round this?

[Idrissshatila]

Hello @Wishmaster91 ,

try countrows.

Top scorer = COUNTROWS(Goalscorers[GoalId])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Wishmaster91]

Thanks for your answer. Unfortunately its still the same result, some of the clubs have the right figure but a couple do not. 

[Idrissshatila]

Hello @Wishmaster91 ,

check if there's any filter that is affecting the data in the report.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Wishmaster91]

Thats where i am stuck

[Idrissshatila]

@Wishmaster91 , 

so click on this icon in the visual you're seeing the value from and you'll get to see if there's any sort of filter affecting the visual.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[Wishmaster91]

Thanks again, heres a screenshot of the filters.

https://ibb.co/vYnfMFW