Skip to main content
Announcements
Jan 15, Trends 2025! Get expert guidance to thrive post-AI with After AI: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ben-powers-trayt
Contributor
Contributor

Measure to show percentage of total using a specific dimension

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?

Labels (3)
1 Reply
rubenmarin

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.