How to rank hierarchy in matrix

[RI]

Hello,
I created a matrix in which i have two hierarchy levels category and brand , a field parameter for selection of parameter.

I want to create ranking based on selection of field parameter. I tried with switch, isinscope but it ranks only one parameter

like i created field parameter for ASP, NSV, DIS% etc but ranking is only happen based on one parameter.

[R00]

please share file.

[Fowmy]

@RI 

Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.