Why control filter work for table level but do not work on KPI level

[sadhanm22]

Hi,
This problem has been solved. the solution is here provided by @David_Wong and it worked exact same way I wanted.

Why parametersied filter do not work on KPI?

@sadhanm22 If you use sum(total_with_A) / sum(total), your conditions are evaluated at the level which is displayed in your visual. That’s why you get different results in a KPI and in a table. If you use total_with_A/total, the conditions are evaluated at the row level. If you want the conditions to always be evaluated at the name level regardless of the visual type, use this instead: sumOver(total_with_A, [name], PRE_AGG) / sumOver(total, [name], PRE_AGG)