Count based on Percentage Category

Hi vinaydavid ,

First of all, we need to create a calculated table as x-axis, you can change the value in this table to generate different category:

x-axis = 
ADDCOLUMNS (
    DATATABLE (
        "MinPercent", DOUBLE,
        "MaxPercent", DOUBLE,
        {
            { 0, 0.2 },
            { 0.21, 0.5 },
            { 0.51, 0.75 },
            { 0.76, 1 }
        }
    ),
    "Category", FORMAT ( [MinPercent], "0%" ) & " - "
        & FORMAT ( [MaxPercent], "0%" )
)

 Then we can create a measure as the value of this chart:

EmplyCount = 
COUNTX (
    FILTER (
        SUMMARIZE (
            'Table',
            'Table'[Emp],
            "Percent", DIVIDE ( SUM ( 'Table'[hours] ), SUM ( 'Table'[Budget hrs] ), 0 )
        ),
        [Percent] > MAX ( 'x-axis'[MinPercent] )
            && [Percent] < MIN ( 'x-axis'[MaxPercent] )
    ),
    [Emp]
)

Best regards,