Percentage of column

[___cw]

Hello,

I am new to power BI and I need to work out the percentage of residents that have valid contact information, (there are 3 different types so mobile, home phone and email address) it will look something like this :

I have a flag within the data that simply states "Yes", "No" or "missing information" for if this resident has valid contact information or not. I essentially need to work out the percentage of the column that is listed as a "yes", then i can repeat for all 3 types.

Please ignore the "lead" and "joint" part, that just states which type of resident they are 🙂

Thanks in advance

[amitchandak]

@___cw , Assume you axis column is col1

and you are using Measure M1 in values

you need a new measure 

divide([M1], calculate([M1], removefilter(Table[Col1]))