Calculate percentage difference between multiple values in same column

[AMBP73]

Hello,

I am trying calculate the percentage between values in the same column, but using more than one value as the difference. For example count of yes and potential (total %) v not reviewed and no. I would like to display % of yes and potential (together) vs total count in a card. I.e. yes/potential is % of total.

Thanks in advance for any assistance 🙂

[AMBP73]

Sorry, yes please

[lbendlin]

=DIVIDE(COUNTROWS(FILTER(table,column in {"Yes","Potential"})),COUNTROWS(table),0)

[lbendlin]

You posted this in the Power Query section.  Do you want this in DAX instead?