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
Solved! Go to 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.
@Mayoman Maybe:
Measure =
VAR __Ranking = MAX('Table'[Ranking])
VAR __Result = IF(__Ranking < 6, "Bad", BLANK())
RETURN
__Result
@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.
User | Count |
---|---|
136 | |
59 | |
56 | |
55 | |
47 |
User | Count |
---|---|
128 | |
77 | |
55 | |
54 | |
51 |