Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |