Forum Discussion
Count all records from another table
Hi All, I have not found a way to do this at all yet, help would be appreciated. It should be relatively straightforward. I have a primary table of submitted records and a larger table with all ...
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.
Headcount =
COUNTROWS(
FILTER(ALL('Table 2'), 'Table 2'[Code] = MAX('Table 1'[Code])
))
PBIX is attached.