Forum Discussion
Count all records from another table
Community ChampionAnonymous - First, you mention Course 1 but I do not see a course 1 in your data. Where you referring to Course 13 and there should be 2 users, one that registered and one that did not?
How are the tables related to one another? Or how are you attempting to relate the tables to one another?
You could just leave them unrelated to one another and do something like:
Measure =
COUNTROWS(
FILTER('Table2', 'Table2'[Course] = MAX('Table1'[Course]) && 'Table2'[TimeFrameCode] = MAX('Table1'[TimeFrameCode]))
)
Something along those lines for example.
Thanks so much Greg_Deckler
There is a course1 there 3 is in the slicer column. I cant seem to get the tables clearer than that.
The tables are currently linked by ID bi directional.
I'll try the formula shortly - frozen screen 😞 at the moment
Hi Greg_Deckler ,
Cant seem to get it working. I have created a pbix file that illustrates my particular issue. I have not linked the tables together in this.
- Greg_DecklerHeadcount =COUNTROWS(FILTER(ALL('Table 2'), 'Table 2'[Code] = MAX('Table 1'[Code])))PBIX is attached.