Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape 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.
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 🙂
Sorry, yes please
=DIVIDE(COUNTROWS(FILTER(table,column in {"Yes","Potential"})),COUNTROWS(table),0)
You posted this in the Power Query section. Do you want this in DAX instead?
User | Count |
---|---|
24 | |
13 | |
11 | |
10 | |
7 |
User | Count |
---|---|
44 | |
26 | |
21 | |
16 | |
12 |