Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago
    Headcount =
    COUNTROWS(
    FILTER(ALL('Table 2'), 'Table 2'[Code] = MAX('Table 1'[Code])
    ))
     
    PBIX is attached.
  • nandukrishnavs's avatar
    nandukrishnavs
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous  If you disable the relationship, it will work. Do you really need relationship between these two tables?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thanks nandukrishnavs  I have tried the calculation with no relationships between the tables. Unfortunately its not working.