cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Percentage of a group

Hi, 

 

I feel like this might be a little more straight forward than I think and I'm overthinking it. 

 

I have a data set that looks something like this:

 

Programapplication #met standard binary
A11
B20
B31
B40
C51
C61
C70
D81

 

What I am looking for is the percentage of programs that are meeting the standard. So if I were to calculate for the above, 75% of programs are meeting the standard, programs A, C and D are meeting the standard. 

 

I believe it's a calculation but I can't figure it out

 

Any help that can be provided would be appreciated. 

 

Thanks in advance, 

 

Vanlang

4 REPLIES 4
jameszhang0805
Resolver IV
Resolver IV

@Anonymous If the standard meeting percentage is 75%, why the Program C passed, Program C just has 3 applications, and 2 applications met the standard, the meeting percentage of Program C should be 66.67%.

jameszhang0805_0-1615345930932.png

 

 

Anonymous
Not applicable

Hi @jameszhang0805 ,

 

I'm not looking for a roll up per project. 

 

What you calculated is absolutely correct. But what I need is a rollup of that table.

 

The 75% I was referring to (the number I need) is that Programs A C and D are meeting the standard at least 50% of the time. 

amitchandak
Super User
Super User

@Anonymous , You can get that with a measure like

 

divide(sum(Table[met]),count(Table[application #]))

Anonymous
Not applicable

Hi Amit,

 

It's not exactly what I am looking for, what I am looking for is a single calculation that will tell me that what percentage of programs made the standard, not what projects did.

 

Thank you though.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors