cancel
Showing results for
Did you mean:
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:

and an example of what I current have:

Any help is appreciated!

Best,

Denisse

1 ACCEPTED SOLUTION

Accepted Solutions
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

4 REPLIES 4
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

@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

Helper I

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?

Solution Sage

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### 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