Having Trouble creating an appropriate measure column

[Anonymous]

Hello Everyone,

I am having trouble creating a column that can accurately represent what I am trying to present. 

The above matrix is what I currently have in Power BI. I am trying to make another column here that will be a percentage column. I need it to be the percentage of "yes" out of the "total."

I cant just use a regular measure, because I want it to calculate for each column. On the back end, Im pullin this info from two data columns. A "Job" column that lists the job to the left, and a "Retire Eligible/5yrs" column that tells me the yes or the no.

This is the DAX measure/column that I was trying, but it doesnt seem to be correct:

As extra information, I just made the "help column" as a column where all cells are equal to 1, since I wasnt able to sum the "job" column as it is non-numerical.

Is there a simple way that I am missing that I can get this to work?

Thank you!

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may create measures like below.For example:

Yes = CALCULATE(COUNT(Table2[Job]),FILTER(Table2,Table2[Eligible]="Yes"))

Percent = [Yes]/CALCULATE(COUNT(Table2[Job]))

Regards,

[Anonymous]

This seems to work! Thank you!