Forum Discussion

Manne_DE's avatar
Manne_DE
Frequent Visitor
2 years ago
Solved

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

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

 

  • 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 

3 Replies

  • Manne_DE's avatar
    Manne_DE
    Frequent Visitor

    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 

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

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

  • 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.