Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
AMBP73
Helper I
Helper I

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 🙂

1693029762224_image001.png

3 REPLIES 3
AMBP73
Helper I
Helper I

Sorry, yes please

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

lbendlin
Super User
Super User

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.