Forum Discussion

joshuavd's avatar
joshuavd
Frequent Visitor
10 years ago
Solved

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...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    joshuavd - I believe you want this:

     

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

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

joshuavd - I believe you want this:

 

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

 

  • joshuavd's avatar
    joshuavd
    Frequent Visitor
    10 years ago

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

    • Greg_Deckler's avatar
      Greg_Deckler
      Icon for Community Champion rankCommunity Champion
      10 years ago

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