Counting People Based On Maximum Result

Hi Atanas_Atanasov ,

Here I create a sample to have a test.

Measure:

Engineer_Count = 
VAR _STEP1 =
    SUMMARIZE (
        ALL ( 'Table' ),
        'Table'[Engineer Email],
        'Table'[BU Name],
        "Count", COUNT ( 'Table'[Engineer Email] )
    )
VAR _STEP2 =
    FILTER (
        _STEP1,
        [Count]
            = MAXX (
                FILTER ( _STEP1, [Engineer Email] = EARLIER ( [Engineer Email] ) ),
                [Count]
            )
    )
RETURN
    COUNTX (
        FILTER ( _STEP2, [BU Name] = MAX ( 'DimBU Name'[BU Name] ) ),
        [Engineer Email]
    ) + 0

Result is as below.

Best Regards,
Rico Zhou

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