Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd like to show project completion rates as a percentage based on the status of the project.
Project.Status can be "complete" or "incomplete"
I'd like to use this measure in a variety of charts to show what percentage of projects are complete by date or by associated organization or by manager etc.
I can make it almost work for 1 chart at a time like this:
num(count([Project ID])/count(ALL <[Project Assigned Date.autoCalendar.Date], [Manager Name]> [Project ID]),'#0%')
Issue 1: That's just showing me all filtered projects as a percentage of the total, so I need to use filters to show any meaningful percentages. ie I still need to filter Project.Status = "complete" to see the metric I want. And that would refuse to show me 0% situations.
Issue 2: That doesn't work on any other charts - if I want a pie chart or to show it by organization rather than manager, I need to make another measure replacing what's in the <brackets>.
Any hints on either issue? Should I be using sets for this?
Hi, I'm not sure to have understood this, in case it helps:
- Try to fix the completed projects on numerator using set analysis:
num(count({<Project.Status={'complete'}>}[Project ID])/count(ALL <[Project Assigned Date.autoCalendar.Date], [Manager Name]> [Project ID]),'#0%')
And/or change ALL to TOTAL so the measure can change with the selections done.