Find the percentage and above tolerance column in shared pbx file

[Saitharunk]

I have shared the pbx file please download , i am unable to find the above tolerance please help me to find this.
https://drive.google.com/file/d/16sbeCYC_LzaFabEkYL-pVF90Gkf2M70u/view?usp=share_link 

above tolerance is not working when i am filtering with any department (value is not showing not correct )

Below image shows with od department filter (working fine with both columns population and above tolerance)

but when i filter with Department the value showing in above tolerance colum is wrong -below image 

Thank you 

[rautaniket0077]

please clarify your requirements, as what is needed, alsp provide the screen shot if possible.

[Saitharunk]

Table 1 

Table 2

Requirement in power bi

with out filtering with Department the result in power bi.

after filtering with Depatment with "Mech", the result showing in power bi.

Can you please do this requirement in power bi and share me PBX file .

[v-zhangti · Accepted solution]

Hi, @Saitharunk 

Based on the data you have provided, you can try the following methods.

Measure:

Precentage = 
Var _N1=COUNT(Table1[Rating])
Var _N2=CALCULATE(COUNT(Table1[Rating]),ALLEXCEPT(Table1,Table1[Department]))
Return
DIVIDE(_N1,_N2)

Above Toerance = 
IF([Precentage]=BLANK(),BLANK(),IF([Precentage]>SELECTEDVALUE(Table2[Toerance]),"Yes","No"))

Result:

Please verify the example data and output.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rautaniket0077]

Hi @Saitharunk ,
please find your pbix file with all the changes, if it solves your issue please accept my answer as solution.
https://drive.google.com/file/d/1SYaDNOfOw6d9ozVrtzxCX5cAF9cKrTF3/view?usp=sharing