Sorting a matrix visual by 2 columns/measures - creating a rank with 2 measures

[Manne_DE]

I have a matrix visual in a client reporting, where I am showing the revenue by client and across the countries where the client had spent. 

I would like to sort this, so that the client which has spent in many countries is at the top, decsending by total spend value.

I have a created a measure which provides me with the info in how many countries the client had spend and I also have the total revenue. 

However, I had not been able to create a ranking measure, which combines these 2 info and sorts the info accordingly.

Here is screen shot of my matrix visual - the client 577 should be listed at the top, followed by the client 263 and then client 447.

I have a test file created, but I cannot see the upload icon to attach it to the post ??

Any support the community can provide, is greatly appreciated.

Thanks, Manfred

[Manne_DE · Accepted solution]

I have now found a way to accomplish this, by using the new RANK function, where I can do a orderby on 2 measures/field. This worked out very well and I have ended up with exactly what I had been looking for.

Thanks 

[MageVortex]

I would probably create a measure that does some sort of multiplicative sum to determine the way I want it ordered, then sort by that measure, but that would probably not work how I wanted in quite a few different instances, so I'm interested in seeing a superior method of resolving this. 

[vanessafvg]

you need to use your own cloud storage and provide the link.