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 ...
Need Help
  • 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

Anonymous's avatar
Anonymous
Not applicable
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] )
)

 

 

 

briodan's avatar
briodan
Frequent Visitor
8 years ago

Thanks that is really close to what I need.

 

I need to only display the Complete status with its value, its ok if users with 0%or blank% show up in the list.

So i guess i need the more complex option.