Forum Discussion
Calculate percentage based on values
You can create a calculated column
grade = IF(yourTable[value]>=5,"5 or above","less than 5")
And then create a measure
perc above 5 = COUNTROWS(FILTER(yourTable,yourTable[value]>=5))/COUNTROWS(ALL(yourTable))
See more details in the attached pbix file. If you'd like more specific suggestion on your scenario, please post some sample data and expected output.
You can create a calculated column
grade = IF(yourTable[value]>=5,"5 or above","less than 5")
And then create a measure
perc above 5 = COUNTROWS(FILTER(yourTable,yourTable[value]>=5))/COUNTROWS(ALL(yourTable))
See more details in the attached pbix file. If you'd like more specific suggestion on your scenario, please post some sample data and expected output.
Hi, I am struggling with something very similar and hope you may be able to help. I want to present the percentage of calls answered within 20s as a gauge byt cant figure out the measure.
Any guidance would be great.
Ringtime KPI Hit 1 Yes 4 Yes 2 Yes 4 Yes 4 Yes 1 Yes 1 Yes 2 Yes 6 Yes 1 Yes 1 Yes 1 Yes 7 Yes 28 No 33 No 22 No 46 No 2 Yes 1 Yes 3 Yes Hi,
I also new to PowerBI but I have the same problem where i need to find percentage every month,
I follow your instruction but the percentage show for 1 year so if i select only january, the percentage not 100% even the data >=5,
this example visual that i get, the data 23.7% is for jan,feb and march..If i select jan is show 3.2%
