Forum Discussion

sohailstsindia's avatar
8 years ago
Solved

CALULATE COUNT AND PERCENTAGE

EMP DATE PROJ A 1/1/2018 P295 A 1/2/2018 P295 A 1/3/2018 P295 A 1/4/2018 P295 A 1/5/2018 P296 A 1/6/2018 P296 A 1/7/2018 P295 B 1/1/2018 P296 B 1/2/20...
  • Zubair_Muhammad's avatar
    8 years ago

     sohailstsindia

     

    May be a MEASURE like

     

    Percentage =
    COUNT ( TableName[DATE] )
        / CALCULATE ( COUNT ( TableName[DATE] ), ALLEXCEPT ( TableName, TableName[EMP] ) )
  • v-xjiin-msft's avatar
    8 years ago

    Hi sohailstsindia,

     

    In your scenario, you are using a date slicer to filter your data. Right?

     

    If so, to achieve your requirement, you can create several measures with expression like below:

     

    Count days based on Emp and Proj:

     

     

     

    Count Days =
    CALCULATE (
        COUNT ( 'Table'[DATE] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[EMP] = MAX ( 'Table'[EMP] )
                && 'Table'[PROJ] = MAX ( 'Table'[PROJ] )
        )
    )

    Count total days based on Emp.

     

    Total Days =
    CALCULATE (
        COUNT ( 'Table'[DATE] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[EMP] = MAX ( 'Table'[EMP] ) )
    )

    Then the percentage will be:

     

    Percentage = [Count Days]/[Total Days] 

    For sure, you can combine above measures into one.

     

     

    Thanks,
    Xi Jin.