Calculate percentage based on values

[carbadine]

Hi

New to Power BI today so apologies if this is very basic.

I am trying to calculate the percentage of grades in Maths column that are 5 or above.

I have added a new measure for this but believe there is no countif function?

Thanks

[Eric_Zhang · Accepted solution]

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.

[LearnfromExpert]

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%

[reynolds_101]

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

[carbadine]

I would also like to be able to view the records of who has that grade.

Thanks