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

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)

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

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.

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

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

Proud to be a Super User!

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!