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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
carbadine
New Member

Calculate percentage based on values

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

 

1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee

You can create a calculated column

grade = IF(yourTable[value]>=5,"5 or above","less than 5")

Capture.PNG

 

And then create a measure

perc above 5 = COUNTROWS(FILTER(yourTable,yourTable[value]>=5))/COUNTROWS(ALL(yourTable))

Capture.PNG

 

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.

View solution in original post

4 REPLIES 4
Eric_Zhang
Employee
Employee

You can create a calculated column

grade = IF(yourTable[value]>=5,"5 or above","less than 5")

Capture.PNG

 

And then create a measure

perc above 5 = COUNTROWS(FILTER(yourTable,yourTable[value]>=5))/COUNTROWS(ALL(yourTable))

Capture.PNG

 

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 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%

 

MicrosoftTeams-image (8).pngMicrosoftTeams-image (7).png

 

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.

 

RingtimeKPI Hit
1Yes
4Yes
2Yes
4Yes
4Yes
1Yes
1Yes
2Yes
6Yes
1Yes
1Yes
1Yes
7Yes
28No
33No
22No
46No
2Yes
1Yes
3Yes
carbadine
New Member

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

 

Thanks

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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