Count Help

Hi,

I am not sure if I understood your question correctly,  but please check the below picture and the attached pbix file.

I tried to create a datamodel like below.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Count employee with 1 or more login: = 
VAR _t =
    ADDCOLUMNS (
        VALUES ( Employee[Employee ID] ),
        "@logincount", CALCULATE ( COUNTROWS ( Data ) )
    )
RETURN
    COUNTROWS ( FILTER ( _t, [@logincount] >= 1 ) )

Percentage employee with 3 or more login: = 
VAR _employeecount =
    COUNTROWS ( VALUES ( Employee[Employee ID] ) )
VAR _t =
    ADDCOLUMNS (
        VALUES ( Employee[Employee ID] ),
        "@logincount", CALCULATE ( COUNTROWS ( Data ) )
    )
VAR _threeormore =
    COUNTROWS ( FILTER ( _t, [@logincount] >= 3 ) )
RETURN
    DIVIDE ( _threeormore, _employeecount )