Forum Discussion

OleMcDonald's avatar
OleMcDonald
Icon for Helper I rankHelper I
5 years ago
Solved

Count records in a joined table

I have two tables [Account] and [Contact] They have a one (account) to many (contact) join  The [Contact] table has a [Job Group] column The [Job Group] is populated with a single value like "CEO"...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi OleMcDonald 

     

    Count of Id for CEO =
COUNTROWS (
    FILTER (
        'Account',
        CALCULATE ( COUNT ( 'Contact'[Job_Group__c] ), 'Contact'[Job_Group__c] = "CEO" ) = 0
    )
)

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

See if this measure works. You shouldn't use COUNTA() here. The only thing it can do that COUNT cannnot is use boolean comparisons, but I don't think you need that. Just count the rows that meet your critera.

Counting Measure =
COUNTROWS(
    FILTER(
        TableName,
        TableName[Field] <> "CEO"
    )
)