i have this scenario, in which i have 3 "solutions" (s1,s2,s3) , each solutions has a "impact" % from the original value
Value = 100
i want to calculate the Percentage of s1 from value ,then the remaining perctenage of s2, and .... s3 from Value,
for example:
STEP 1 - 50% (s1) from 100 = 50
STEP 2- then 50%(s2) from WHAT IS REMAINING from STEP1 = 50% from 50 = 25
STEP 3 then 50%(s3) from WHAT IS REMAINING from STEP2 = 50% from 25 = 12.5
solutions impact value explain s1 50% 50 50% from the original 100 value s2 50% 25 50% from the "last row" value which is 50, so 50% from 50, 25 s3 50% 12.5 and now 50% from 25
how do i build a DAX measure for this please ? / way to make this work