Forum Discussion
briodan
8 years agoFrequent Visitor
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 ...
- Anonymous8 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] )
) - Anonymous8 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
8 years agoNot applicable
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