Forum Discussion
Solved
Filter Table
Hi guys, Could someone help me, please? I would like to filter the following table: I am using the following formula to return values that are different from '-9' or bigger then "0", but t...
Hello
Why not apply a simple criterion in the <>-9 filter panel.
Hi,
You could use this check measure:
___check = if ( COUNTROWS(FILTER('Table','Table'[id]<>-9 || 'Table'[id] >0))>0,1, BLANK())
as seen here:
Link to file.
Please mark as solution if so. Thumbs up for the effort are appreciated.
Kind regards,
Steve.
@stevedep I want to return the values, in the case of this example the number 4, 6, 7 and 8. All that contain -9 will not be presented in a visualization table for example
It's filtering the rows in the table, therefore you get the values you are looking for?
Hello
Why not apply a simple criterion in the <>-9 filter panel.