Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

Need Help
  • nandic's avatar
    nandic
    6 years ago

    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

     

4 Replies

  • nandic's avatar
    nandic
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        nandic
        Icon for Resident Rockstar rankResident Rockstar
        6 years ago

        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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    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.