% of unique values in a column based on the value of another column?

[jmscrx]

Hi folks, new to the community and PowerBI. I've been able to solve most of my basic issues so far via searching here and trial and error, thanks for all your contributions to this community. It's amazing how well versed everyone is with such a powerful tool.

Anyway, my data is similar to the below.

Vendor Name	Needs Remediation
Vendor1	Yes
Vendor1	Yes
Vendor2	No
Vendor2	No
Vendor2	No
Vendor2	No
Vendor3	No
Vendor3	Yes
Vendor3	Yes
Vendor3	Yes
Vendor3	Yes
Vendor3	No

What I'd like to do with a visual is to calculate/display the "percentage of vendors with findings that need remediation." I'm not sure if this would be a measure, calculated column or similar and the likely needed DAX is a bit over my head at this early stage. So with the above data my outcome would simply be a percentage that considered Vendor1 and Vendor2 (2 total unique vendors) as a percentage of all unique vendors (3 total in this case). Said differently, I want to calculate the percentage of unique vendors with a Yes in column 2 based on the number of overall unique vendors from column 1. 

In this case it would be 2 unique vendors calculated as a percentage of 3 total. I hope I'm explaining this correctly and feel like I'm over thinking it :). Thanks!

[AlexisOlson]

You probably want a measure similar to this:

NeedsRemediation% =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( Table1[Vendor Name] ),
        Table1[Needs Remediation] = "Yes"
    ),
    DISTINCTCOUNT ( Table1[Vendor Name] )
)

[jmscrx · Accepted solution]

Thanks for the quick reply, this makes sense and seems to work when used in a card visual!!!