Hi Everyone,
I am trying to have a measure or some other way to automatically calculate the target that each subject must meet in order to achieve the fixed annual target set based on dynamic data model.
For example:
the annual target is to have <=20% of defect overall YTD
the subjects are countries; japan (30% defect rate), taiwan (13%), turkey (10%), finland (26%), spain (10%), nigeria (6%), indonesia (13%), new zealand (21%), UK (9%) etc
If I only wish to control and set a target for the defect rate of japan, finland and nigeria to meet the annual target of <=20% overall defect rate, how do we go about creating a measure to calculate this? If based on the current data, I can simply do the calculation for these countries, but since data is dynamic and changes every day, is it possible for a measure to do such complex backward calculation based on logic of <=20%?
