topic Re: Percentage of a group in DAX Commands and Tips

Percentage of a group

Anonymous — Tue, 09 Mar 2021 03:01:09 GMT

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:

Program	application #	met standard binary
A	1	1
B	2	0
B	3	1
B	4	0
C	5	1
C	6	1
C	7	0
D	8	1

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

Re: Percentage of a group

amitchandak — Tue, 09 Mar 2021 04:59:07 GMT

Anonymous , You can get that with a measure like

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

Re: Percentage of a group

Anonymous — Tue, 09 Mar 2021 20:02:24 GMT

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.

Re: Percentage of a group

jameszhang0805 — Wed, 10 Mar 2021 03:12:36 GMT

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%.

Re: Percentage of a group

Anonymous — Wed, 10 Mar 2021 13:13:53 GMT

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.