Calculating a percentage of filtered records VS overall records

[graemejohnson]

Hi, this is my first posting, and I've only been using PowerBI for a week, so please go easy on me....

My scenario is that I'm attempting to report on Software deployments (aka Changes).

My data model is very simple

• I have a table named 'Change' with a row per change
• A change can be attributed to a project (as shown by the slicer in the image below)
• A change can have a Status of 'Change Succeeded' or 'Change Failed'

One of my objectives is to calculate the percentage of Changes that have a status of 'Change Failed' - so for example, with the data shown in the screen grab below it would expect 3.41% to be shown i.e. (Failures/Change Count)*100 or  (4/117)*100.

In reference to the image below with the numbers in red circles...

(1) is a count of changes for the selected project(s) - all good

(2) is a count of changes for the selected projects, with a visual level filter on 'Status Name' to only count rows where it's 'Change Failed' - all good

(3) is a percentage of changes for the project(s)  and is a measure defined as

Change % = (Change[Change Count]/[Count All Rows])*100

(4) is what I was hoping was going to show 3.41% - but it's showing 0.33%.

I've a feeling that what's missing is a CALCULATED measure, but I'm at a loss where to start - please can someone give some advice?

These are the visual filters I am applying to (4)

Many thanks

Graeme

[HotChilli · Accepted solution]

The 0.33 comes from the Percentage Change figure(9.79) x 4/117. It's a percentage of a percentage.

One way to get what you want I think is :

Count Failed % = CALCULATE(COUNTROWS(Change), Change[Status] = "Change Failed") / COUNTROWS(Change)

[HotChilli · Accepted solution]

The 0.33 comes from the Percentage Change figure(9.79) x 4/117. It's a percentage of a percentage.

One way to get what you want I think is :

Count Failed % = CALCULATE(COUNTROWS(Change), Change[Status] = "Change Failed") / COUNTROWS(Change)

[graemejohnson · Accepted solution]

Thank you so much @HotChilli .   That worked for me.

I genuinely appreciate the assistance - thanks once again!