How to create a calculated row in a column using DAX?

Hi mdrammeh,

For your first scenario, how to calculate the percentage? Could you please give an example based on your sample table.

For your second scenario, you can create a calculated column to get the absolute value of the cost variance between scope and target dollars using the formula

cost variance=ABS('DE Scope Target'[Scope] - 'DE Scope Target'[Target Dollars])

Then get the expected result based on the calculated column as follows.

result=IF('DE Scope Target'[cost variance]>=51,"Needs Improvement",IF('DE Scope Target'[cost variance]>=25,"Good",IF('DE Scope Target'[cost variance]>0,"Very Good","Excellent")))

Finally, you want to get Maximum and Minimum Target Dollars, which means the Maximum and Minimum of all Target Dollars? If it is, your [Max Target Dollars] and [Min Target Dollars] are uncorrect. You should calculate them using the formulas.
 

Max Target Dollars=CALCULATE(MAX('DE Scope Target'[Target Dollars]),ALL('DE Scope Target'))

Min Target Dollars=CALCULATE(MIN('DE Scope Target'[Target Dollars]),ALL('DE Scope Target'))

Best Regards,
Angelia