Forum Discussion

briodan's avatar
briodan
Frequent Visitor
8 years ago
Solved

Percent complete by category

I need to calculate the percent complete of tasks assigned to users Here is what my data looks like: User Task Status a 1 start a 2 progress a 3 progress a 4 complete b ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Here is a solution.

     

    It gets more complex if you want to apply FILTER() to the formula so that person b will show up and you do not need to show all categories.  If filtering for Complete, person b will not show up.  In the FILTER() case, the Measure is hard coded for Complete.

     

    Here is the measure and a snippet below showing my results using your provided data:

     

    % of Status =
    COUNT ( data[Status] ) / CALCULATE (
    COUNT ( data[Status] ),
    ALLEXCEPT ( data, data[User] )
    )

     

     

     

  • Anonymous's avatar
    Anonymous
    8 years ago

    briodan,

    You can create a measure using DAX below.

    Pecent complete = DIVIDE(CALCULATE(COUNTA(data[Status]),FILTER(data,data[Status]="complete")),COUNTA(data[Status]))+0


    For more details, please review attached PBIX file.

    Regards,
    Lydia