cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mayoman
New Member

Show lowest 5 in a Table

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

1 ACCEPTED SOLUTION

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Greg_Deckler
Super User
Super User

@Mayoman Maybe:

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@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

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.