Percentage of value

[EMILKDIT_2022]

I'm trying to produce the following, would anyone mind giving some inputs on how this can be done? 

Dataset: 

Name	Location	Pass?
Carly	New York	PASSED
Carsten	San Francisco	PASSED
Emily	New York	NOT PASSED

What I'd like to present in Power BI: 

Location	Pass % of location
New York	50%
San Francisco	100%

[Jos_Woolley · Accepted solution]

Hi,

Create a new measure:

Pass % of location =
VAR Passed =
    CALCULATE(
        COUNTROWS( 'Table' ),
        'Table'[Pass?] = "PASSED"
    )
RETURN
    DIVIDE(
        Passed,
        COUNTROWS( 'Table' )
    )

which can then be placed in, for example, a Table Visual, alongside the Location field.

Regards