Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
(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
Solved! Go to 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)
Thank you so much @HotChilli . That worked for me.
I genuinely appreciate the assistance - thanks once again!
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)
Thank you so much @HotChilli . That worked for me.
I genuinely appreciate the assistance - thanks once again!
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |