topic Find the percentage of (count of rating) and Above Tolerence (percentage >Tolerance =Y) in DAX Commands and Tips

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

Saitharunk — Sat, 15 Apr 2023 01:50:45 GMT

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 — Sat, 15 Apr 2023 03:33:46 GMT

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.