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

Highlighted
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

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

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

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