bottom 5 dax not working

Hi ROG ,

Based on the information you have provided, you can follow these steps:

1.Add new column

ranking =

RANKX ( ALL ( 'Table' ), 'Table'[No Port-Outs],, DESC, DENSE )

2.Add new column

new carrier =

IF ( 'Table'[ranking] <= 5, 'Table'[carrier], "Others" )

3.Put in Matrix

Final output:

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

^{Best Regards,}

^{Yifan Wang}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}