Forum Discussion

karinafreitass's avatar
karinafreitass
Icon for Helper III rankHelper III
5 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hello

    Why not apply a simple criterion in the <>-9 filter panel.

stevedep's avatar
stevedep
Icon for Memorable Member rankMemorable Member
5 years ago

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. 

karinafreitass's avatar
karinafreitass
Icon for Helper III rankHelper III
5 years ago

@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

  • stevedep's avatar
    stevedep
    Icon for Memorable Member rankMemorable Member
    5 years ago

    It's filtering the rows in the table, therefore you get the values you are looking for?

    • karinafreitass's avatar
      karinafreitass
      Icon for Helper III rankHelper III
      5 years ago

      @stevedep ,

      I still couldn't get it.

      Below is the result I would like:

      Screenshot (102).png

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        5 years ago

        Hello

        Why not apply a simple criterion in the <>-9 filter panel.