Show lowest 5 in a Table

[Anonymous]

Hello everyone,

im currently working in PowerBI and trying to solve a little problem...

Im Working in a Table Called "Lieferantenübersicht" in which are a lot of Columns. Now i just want to show the lines which include the Numers 1 to 5 (Column Name "Rating")

--> I want to show the lowest 5 suppliers out of 30 suppliers in a Table. I already rated every one and gave him a rating between 1 (bad) and 30 (very good)

How do i fix the Problem? I would like to use a measure and not a visual filter

[Greg_Deckler]

@Anonymous Maybe:

Measure = 
  VAR __Ranking = MAX('Table'[Ranking])
  VAR __Result = IF(__Ranking < 6, "Bad", BLANK())
RETURN
  __Result

[Anonymous]

@Greg_Deckler 
Thank you, but i dont want to show "bad" in Table. I just want to Show the suppliers with the rating 1-5 in the Table. The other 25 suppliers should not be seen in the Table after the measure

[Greg_Deckler · Accepted solution]

@Anonymous Well, you could do this:

Measure = 
  VAR __Ranking = MAX('Table'[Ranking])
  VAR __Result = IF(__Ranking < 6, " ", BLANK())
RETURN
  __Result

Bottom line, if you don't want a visual filter involved at all (not sure why not since a top N filter would do this marvelously) then you have to have a measure that returns *something* for the cases you want to show and otherwise return BLANK(). If you put the supplier name in a table along with this measure then only the rows that return *something* will show.