Calculate Top 5 Brands Based on Manufacturers Rank one manufacturer's brand first compared to other

[Anonymous]

Can anyone assist me on this?

Manu Rank 2 = if(max('Actuals Data'[Regional_Manufacturer])="Abc",0,

    Calculate(RANKX(ALL('Actuals Data'[Regional_Brand]),

                  [SUM OF TOTAL],,,Dense)))

[Anonymous]

Hi @Anonymous 

Can you provide a sample for us ? 

Best Regards,
Community Support Team _ Ailsa Tao

[stevedep]

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523