Forum Discussion

mvgust's avatar
mvgust
Icon for Helper III rankHelper III
3 years ago
Solved

Count Employees With Hours >= 25%

I've setup a data table where I'm calculating each employee's union hours as a percentage of total hours per week.  What I need to do, is count the number of employees which have at least one week wi...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    try to create a measure with the code below:

     

    Count =
    COUNTROWS(
        FILTER(
            VALUES(Data[Employee - HID]),
            CALCULATE(MAX(Data[% of Total]))>=0.25
        )
    )
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

try to create a measure with the code below:

 

Count =
COUNTROWS(
    FILTER(
        VALUES(Data[Employee - HID]),
        CALCULATE(MAX(Data[% of Total]))>=0.25
    )
)