DAX counting based on two tables and a filter

[joshuavd]

Just want to start off with a thanks.  I am new to DAX and the help I have been offered here is incredibly helpful to my learning.

Now the issue.  This is the table schema I have:

I want to calculate won games by player.  A player has won when their score equals 10 in the table Foosey.

I have this formula which is counting total won games and not won games by person (see picture below).  I am missing one piece of the formula but can't seem to get it right.  Could someone help me get the rest of the way?

[Greg_Deckler · Accepted solution]

@joshuavd - I believe you want this:

Won = CALCULATE(COUNTROWS(Foosey),FILTER(RELATEDTABLE(Foosey),Foosey[Score]=10))

[joshuavd]

That is exactly what I was looking for!  Thank you for saving my bacon again!

[Greg_Deckler]

Well, your next one is a doosy, so we'll see how that one goes!