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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

VALUES() returns a table.  You can't use CALCULATE with that  - you would need to use CALCULATETABLE().

 

Both of these cannot be the final result of your measure - you need a single ("scalar") value.

 

What should the result of the measure be? A yes/no value?

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

    @lbendlin 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

      Ah, I misread, it should be <> -9 

      In the measure definition that I shared. You should be good then since it will return the rows that meet the filter criteria. Pls take a look.