Filter Value of Measure

[tameemyousaf]

I have a measure that shows below values in grid.

"Stock Exc/Def" is not the column its a measure. I want to filter the values and want to get the values that are -ve. I don't want to use visual level filter. I want to do it only by creating a new measure. How can I do this?

I have tried the following but failed. 

Stock Exc/Def Less than zero = CALCULATE([Stock Exc/Def], FILTER('myTable', [Stock Exc/Def] < 0))

[gapage · Accepted solution]

=IF (
    [Stock Exc/Def] < 0,
    [Stock Exc/Def],
    BLANK ( )
)

[tameemyousaf]

Thanks @gapage