cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper III

## Filter Table

Hi guys,

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(
FILTER('Lançamento',
)
Return
Codigo

Which formula could I use?

Thanks,

Karina

1 ACCEPTED SOLUTION
Super User

Hello

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
8 REPLIES 8
Memorable Member

Hi,

You could use this check measure:

``___check = if ( COUNTROWS(FILTER('Table','Table'[id]<>-9 || 'Table'[id] >0))>0,1, BLANK())``

as seen here:

Please mark as solution if so. Thumbs up for the effort are appreciated.

Kind regards,
Steve.

Proud to be a Super User!

Helper III

@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

Memorable Member

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

Proud to be a Super User!

Helper III

I still couldn't get it.

Below is the result I would like:

Super User

Hello

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

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

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?

Helper III

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

Memorable Member

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.

Proud to be a Super User!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors