Forum Discussion

AMBP73's avatar
AMBP73
Icon for Helper I rankHelper I
3 years ago

Calculate percentage difference between multiple values in same column

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 🙂

Tutorial Requests

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

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

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

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