Forum Discussion
tameemyousaf
Helper I
8 years agoFilter 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
- gapage
Advocate I
=IF (
[Stock Exc/Def] < 0,
[Stock Exc/Def],
BLANK ( )
)- tameemyousaf
Helper I
Thanks gapage