Forum Discussion
Solved
Show 3 highest values based on condition
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 “lo...
Make it more flexible,
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.
