Forum Discussion

Helper 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 there is an error.

Cod. Lançamento =

VAR Codigo = CALCULATE(

VALUES('Lançamento'[Não Identificado]),

FILTER('Lançamento',

'Lançamento'[Não Identificado] >= 0)

)

Return

Codigo

Which formula could I use?

Thanks,

Karina

Ashish_Mathur
5 years ago
Hello

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

8 Replies

lbendlin
Super 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
  Helper 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
    Memorable 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.
stevedep
Memorable 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
  Helper 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
    Memorable Member
    5 years ago
    It's filtering the rows in the table, therefore you get the values you are looking for?

Related content