how to use PowerBi filter top 10 negative number

[oscarr29]

anyone know how to use PowerBi to filter Top 10 Top 5 Top 3 negative number?

example: 
kent -2000
jack -3000
kiki 2000
yuki -1000
yoyo 3000

i want result:
Jack -3000
kent -2000
yuki -1000

[jthomson]

TOPN has an option to sort ascending or descending

[oscarr29]

already tried TOPN, cannot ascending or descending, and that way is very troublesome...

actually i want like this,  https://www.youtube.com/watch?v=SsZseKOgrWQ&feature=youtu.be

but this one no teach how to filter negative number, and i'm tried got some error there.

[Vvelarde]

@oscarr29

Hi, Try with this method:

Create a Table with:

Create a measure to Rank:

Ranking =
RANKX ( ALLSELECTED ( Table1 ); CALCULATE ( SUM ( Table1[Profit] ) );; ASC )

Create another measure to include or exclude in the visual:

InTop =
VAR TOPSELECTED =
    SELECTEDVALUE ( Tops[Top] )
RETURN
    IF ( [Ranking] <= TOPSELECTED; "INCLUDE"; "EXCLUDE" )

Alternative 1

And in the Visual LeveL Filter

Alternative 2

In your Profit Measure add this:

ProfitM =
IF ( [InTop] = "INCLUDE"; SUM ( Table1[Profit] ); BLANK () )

Ready.

Regards

Victor

Lima - Peru

[oscarr29]

Hi @Vvelarde

i use your formula got 1 problem, if i choose filter top 3 client, there will filter negative and positive value...

i want that results is separate top 3 negative value client and top 3 positive  value client...can make that negative and positive button to choose ?

[Vvelarde]

 @oscarr29

Review this PBIX File, this give you a path to solve your problem.

LINK

Regards

Victor

[oscarr29]

Hi @Vvelarde

Can you do a multi filter with top 10 client and negative or positive number ?

Thanks