My report is returning the wrong values

[WheelchairWilly]

As you can see from the first ss, this shows that say Manchester City won the game 3-0 but when you look at when this results is converted to a report in Power BI (2nd ss) it shows that Manchester City did not win thus it is missing the three points which should show in this report. Other teams have lost matches but the report shows up as a win? The GF & GA are showing up as correct?? Any idea as to what is going on? 

[WheelchairWilly]

For Won & Points I use [Add Column-Conditional Column]. For Draw & Lost I use Custom Column {If result = "R" then 1 else 0]

I did this for last years matches and did not encounter anything like this. I've tried everything under the sun for the last week but whatever I change I still keep getting the same problem. I got my instructions from a Power BI video-Building the English Premier League Table with Power BI - YouTube

[ahmedoye · Accepted solution]

Hi @WheelchairWilly , you need to give an idea of what your power bi data model looks like and how you created the calculations for your Won, Draw, Lost, etc.