Can a measure be used in a calculated column

[akhaliq7]

I have a requirement whereby I need to get the start and end date from a date field. I have done this using two measures. Now I need to use the two measures in a if statement ideally in a calculated column but wanted to know if it can be done as I am getting all 0s even though I should have some 1s being returned.

My use case is comparing another date field to see whether it is in between the start and end dates. if it is return 1 else return 0

[johnt75]

Yes, you can use measures in calculated columns but you need to be careful about filters. If the table you are adding the calculated column to filters the tables which the measures you are using evaluate then you may need to use REMOVEFILTERS if the measures should be looking at the entire dataset.

[amitchandak · Accepted solution]

@akhaliq7 , you should not measure in a column. Also you can not use slicer value in column