Filter Table

[karinafreitass]

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

[stevedep]

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]

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

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

[karinafreitass]

@stevedep ,

I still couldn't get it.

Below is the result I would like:

[Ashish_Mathur · Accepted solution]

Hello

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

[lbendlin]

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]

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

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.