The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a big table in Power BI where I want to write a DAX Expression to create a new table for each location only to show the 3 highest “losses” values.
But sometimes some rows have the same “losses” values therefore I want to show the rows even if they have the same number of “losses” values.
For example, if I filter by “location06” and select the highest 3 numbers:
ID | Location | Losses |
16743 | Location06 | 300 |
16744 | Location06 | 300 |
16742 | Location06 | 255 |
16753 | Location06 | 150 |
But in case the Losses number is repeated then this is what I want to see:
ID | Location | Losses |
16743 | Location06 | 300 |
16744 | Location06 | 300 |
16742 | Location06 | 255 |
Link to sample datesource file Excel sheet
Solved! Go to Solution.
Make it more flexible,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Hi,
Try these measures
L = SUM(Data[Losses])
Measure = RANK(DENSE,ALL(Data[ID]),orderby([L],DESC,Data[ID],ASC))
Expand the filter pane and select <=3 as the filter criteria. Hope this helps.
Hi,
Try these measures
L = SUM(Data[Losses])
Measure = RANK(DENSE,ALL(Data[ID]),orderby([L],DESC,Data[ID],ASC))
Expand the filter pane and select <=3 as the filter criteria. Hope this helps.
Hi @2019
How about this? The are 2 records each for 300 and 255.
Proud to be a Super User!
Please see attached pbix. Visually filter the table to Show? = 1 or not blank.
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
141 | |
109 | |
107 | |
75 | |
61 |
User | Count |
---|---|
276 | |
129 | |
122 | |
100 | |
88 |