How do i solve for Employee Count is linked to Department, Section and Sub Section

Hi Anonymous ,

The mostly is the relationship between these table. you should make sure that these tables have active relationship between them, then you can just use the measure which looks like you provided.

Or please modify the measure like the code below:

MJK Employee Count =
COUNTROWS(
    FILTER(
        ALL( 'MJK Total Employees' ),
        'MJK Total Employees'[Department]
            = SELECTEDVALUE( 'this table Employees'[Department] )
            && 'MJK Total Employees'[Section]
                = SELECTEDVALUE( 'this table Employees'[Section] )
            && 'MJK Total Employees'[Sub Section]
                = SELECTEDVALUE( 'this table Employees'[Sub Section] )
    )
)

The link to your pbix is not accessible.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.