cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Percent Reaching a Goal

Hello everyone, 

 

I'm new to PowerBI and I've been trying to create a calculated measure that counts the total of rows that = "pass" and divides it by the total number of rows in general. The goal here is to have a graph that shows the percent that reached a benchmark. 

 

I have a column that is of travel times in seconds. I created a new column that distinguished if the travel time was <= 330 'Pass", or >330 'Fail'. 

 

I wish to now show what percent received a 'pass'. Ideally, 90% would receive a pass. 

 

Here's an example of my GOAL: 

percent meeting goals.PNG

 

and an example of what I current have: 

testing.PNG

 

Any help is appreciated! 

 

Best, 

 

Denisse

1 ACCEPTED SOLUTION

Accepted Solutions
Solution Sage
Solution Sage

@ruesaintdenis ,
Try this formula:

Pass % =
var _pass = CALCULATE(COUNTROWS(Sales),Sales[Criteria]="Pass")
var _totalRows = COUNTROWS(Sales)
RETURN
DIVIDE(_pass,_totalRows)

* Sales is name of the table
pass fail %.PNG

 

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

@ruesaintdenis Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Solution Sage
Solution Sage

@ruesaintdenis ,
Try this formula:

Pass % =
var _pass = CALCULATE(COUNTROWS(Sales),Sales[Criteria]="Pass")
var _totalRows = COUNTROWS(Sales)
RETURN
DIVIDE(_pass,_totalRows)

* Sales is name of the table
pass fail %.PNG

 

View solution in original post

Hi @nandic 

 

Thanks a million, this seems to work! Would you know how I can differentiate the bars as red if below 90% and blue if above 90% like my example/goal picture shows? 

 

 

@ruesaintdenis , glad it helped!
Select chart, got to formatting > data colors > click on Fx button beside color and add rules (in my example border is 45%, just type 90 for your example)

cond format chart.PNG

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors