Forum Discussion

tameemyousaf's avatar
tameemyousaf
Icon for Helper I rankHelper I
8 years ago
Solved

Filter Value of Measure

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))

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

2 Replies