Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
@joshuavd - I believe you want this:
Won = CALCULATE(COUNTROWS(Foosey),FILTER(RELATEDTABLE(Foosey),Foosey[Score]=10))
@joshuavd - I believe you want this:
Won = CALCULATE(COUNTROWS(Foosey),FILTER(RELATEDTABLE(Foosey),Foosey[Score]=10))
That is exactly what I was looking for! Thank you for saving my bacon again!
Well, your next one is a doosy, so we'll see how that one goes!