IF Negative value

Hi AllanBerces 
You can add custom column with the formula :
if [Progress]<0 and [#"Work %"]=100 then [Plan] 
else [Progress]

Please note :
You don't need a column if the goal is to put the calculation in visualization, you can just create a measure like :

test measure =

if( max('Table'[Progress])<0 && max('Table'[Work %])=100,sum('Table'[Plan]),sum('Table'[Progress]))

More information about differenses between calculated columns vs measures here :
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

The pbix with the example is attached

AllanBerces 

you can try this

= if [Progress]<0 and [#"Work%"]=100 then [Plan] else if [#"Work%"] = 100 then [Progress] else if [#"Work%"]=0 then [Plan] else [Progress]

Hi again , then the formula will be :
PQ:

You can add custom column with the formula :
if [Work%]<0 =0 then [Plan] 
else [Progress]

 Dax :

Test measure =

if(  max('Table'[Work %])=0,sum('Table'[Plan]),sum('Table'[Progress]))

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.