I have below data frame:
Employee Grade Opening Number Avg Salary ($) Promotions In Promotions Out Closing Number
Grade I 531 90K 10 0 541
Garde II 750 821K 25 10 765
Grade III 1490 73K 31 25 1496
Grade IV 2189 61K 42 31 2200
Grade V 3730 47K 0 42 3688
Total 8690 108 108 8690
Question is how to create a Dax Formula which allows to Add Promotions Into that grade Using Slicer and simultaneous reduction of Same Number of Promotions Out from that Grade. Also Grade at the Bottom (Grade V) has No promotions Into as it is Entry level while Grade I is the Highest and hence No Promotions Out as it is Highest Level.
Opening Employee Count and Closing Employee Count has to be same as Promotions Into and Promotions Out nullify each other.
Looking forward to any help on this