how to create a column to subtract a measure from a column

[Nicki]

I have a column in  [table A] that has the value of Duration and it is integer. 

The value of slicer is calcuated  as a measure:

        Measureslicer = VALUE(MAX(tableB[DURATION])) 

Then,  I need to have a column for my chart.

new column= if (TableA[Duration] - Measureslicer >1 ,1,0)

It does not work  and shows 0 for all rows.

For example, when Duration  is  3  and Measureslicer  is  11 ,

If I assign Measureslicer to a  column  and it will be 30840 instead of 11 but I can see the correct value of measure "11" as a measure. because of this reason subtract and if statement does not work.  

In fact, the value of measure is not correct when assign to a column or  doing subtract.

Thank you in advance for help.

[ccakjcrx]

Hey @Nicki!

You reference two tables in your post. Do you have two tables, or one? If you have one table, the if statement is working correctly.

The measure returns the maximum value from the column.

The if statement then subtracts the maximum value (generated from the measure) from each value in the duration column; this won't produce a value greater than 1. Given the if statement is set up to return 0 if duration - max duration < 1, you should get a zero in each row under your new calculated column.

[Nicki]

Thanks.

How can I use the selected value of slicer?

In this case, I do not need to put the max(duration) from slicer.

the slicer is  "less than or equal to"  and I need the second value.

[Nicki]

MDuration is a measure in [DurationTable] that includes the selected value of  the slicer.  For example for duration= 100  , new column must be 1 but it is zero. 

I can show in an image and It does not work,

[parry2k]

did you used the DAX I provided.

[Nicki]

Yes.

[parry2k]

new column =
var myMeasure = [measureslicer]
return if(Table[Duration] - myMeasure > 1, 1, 0)