Forum Discussion
joshuavd
10 years agoFrequent Visitor
DAX counting based on two tables and a filter
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 t...
- 10 years ago
joshuavd - I believe you want this:
Won = CALCULATE(COUNTROWS(Foosey),FILTER(RELATEDTABLE(Foosey),Foosey[Score]=10))
joshuavd
10 years agoFrequent Visitor
That is exactly what I was looking for! Thank you for saving my bacon again!
Greg_Deckler
Community Champion
10 years agoWell, your next one is a doosy, so we'll see how that one goes!