Find the percentage of (count of rating) and Above Tolerence (percentage >Tolerance =Y)

[Saitharunk]

Table 1 contains -Emp ID,Rating(1-5),Department

Requirement to create in power bi as shown below 
create a count of rating and percentage.

if i filter with Department like CSE then the data also need to filter like given below screenshort.

can you please find the Percentage > Tolerence (if it is true then keep "Y" or keep "N")

please help me to find the Above Tolerence column .

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

I do not know how to get the information of the tolerence, so I just assumed it is 0.30 in my sample.

If you have your own logic how to get the tolerence information, you can create your own.