DAX - new column for a table that is simply an old column excluding certain values

[Anonymous]

I feel like this should be very easy but I can't get it to work. I have MYTABLE which has a column MYTABLE[active_ids] which has some values I need to exclude for a visualisation. I want to create a new column that is MYTABLE[active_ids] where the values are <= 100, introducing blanks for the values over 100. 

I've tried

column = MYTABLE[active_ids] <= 100

which naturally returns logical values. 

If I were to do this in SQL it would be:

CASE
 WHEN MYTABLE.active_ids > 100
 THEN NULL
 ELSE MYTABLE.active_ids
 END

Please help!

 Thanks.

[Gordonlilj · Accepted solution]

Hi,

See if this gives the result you want

column = if(Table1[Column] > 100,BLANK(),Table1[Column])