Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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 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%
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 |
I would also like to be able to view the records of who has that grade.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |