Forum Discussion
Is my data model ok?
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
A simple dax formula like below does not give the right result so i am confused.
Top scorer = COUNT(Goalscorers[GoalId])
9 Replies
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đź’ˇThanks for your answer. Unfortunately its still the same result, some of the clubs have the right figure but a couple do not.
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đź’ˇ
Still having trouble, is it possible to upload my power bi file?
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đź’ˇ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?
