Percent Reaching a Goal

[Anonymous]

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: 

and an example of what I current have: 

Any help is appreciated! 

Best, 

Denisse

[nandic · Accepted solution]

@Anonymous ,
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

[Anonymous]

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? 

[nandic]

@Anonymous , 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)

[Greg_Deckler]

@Anonymous 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.