Getting percentage of rows with a certain value in one column for a card visual

[jaduncan0515]

This seems like it should be relatively simple, but I am struggling with it.

I have one table that looks like the below (the blanks are intentional):

Project ID	Project Type	Status	Diverse
1	A	Active	Yes
2	A	Complete	Yes
3	B	Complete	No
4	C	Active	Yes
5	A	Pending	No
6	A	Pending

The page I want the card visual on has the below filters which I want to keep for the card visual:

Page Filters

Project Type = "A"

Status = "Active" or "Complete"

I need to return this value for the visual after all the filters (50% is taken from the dummy data in the table above):

Result Needed

% of rows where Diverse = "Yes" = 50%

[gmsamborn · Accepted solution]

Hi @jaduncan0515 

Would a measure like this help?

Pct Diverse = 
VAR _All = COUNTROWS( 'Table' )
VAR _Diverse =
    CALCULATE(
        COUNTROWS( 'Table' ),
        'Table'[Diverse] = "Yes"
    )
VAR _Result = 
    DIVIDE(
        _Diverse,
        _All
    )
RETURN
    _Result

Pct Diverse.pbix

Let me know if you have any questions.

[jaduncan0515]

Worked like a charm. Thank you very much!