Forum Discussion

joshuavd's avatar
joshuavd
Frequent Visitor
10 years ago
Solved

DAX Counting across two tables with multiple columns

I have two tables representing our foosball games played in office.  The first is what is generated by our software that has these columns:   A game can either be a single or doubles   I ...
Need Help
  • Sean's avatar
    Sean
    10 years ago

    joshuavd 

    Type = IF ( COUNTROWS ( RELATEDTABLE('Foosey') ) = 2, "Singles", "Doubles")

Sean's avatar
Sean
Community Champion
10 years ago

joshuavd 

Type = IF ( COUNTROWS ( RELATEDTABLE('Foosey') ) = 2, "Singles", "Doubles")

joshuavd's avatar
joshuavd
Frequent Visitor
10 years ago

Thanks!  I had tried this previously but it wasn't working, on further investigation I realized that I had not created a relationship between the tables... rookie mistake!  Really appreciate it!

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    joshuavd - Glad you got it resolved, that's why I always try to call out assumed relationships when posting answers!