Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Order a visual table by multiple measures

Hi all, I've created a table visual in which I want to display the invoice net amount for every customer under a sales force agent. I've created some measures in order to display the net amount over...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi Anonymous ,

     

    We can create a measure and put it into table visual to meet your requirement:

     

    rank = 
RANKX(SUMMARIZE(ALLSELECTED('Table'),'Table'[Agent]),[Agent],SELECTEDVALUE('Table'[Agent]),ASC,Dense)/DISTINCTCOUNT('Table'[Cliente])/1
+RANKX(SUMMARIZE(ALLSELECTED('Table'),'Table'[Agent],"2014c",[2014]),[2014c],[2014],ASC,Dense)/DISTINCTCOUNT('Table'[Cliente])/10
+RANKX(SUMMARIZE(ALLSELECTED('Table'),'Table'[Agent],"2015c",[2015]),[2015c],[2014],ASC,Dense)/DISTINCTCOUNT('Table'[Cliente])/100
+RANKX(SUMMARIZE(ALLSELECTED('Table'),'Table'[Agent],"2015c",[2015]),[2015c],[2014],ASC,Dense)/DISTINCTCOUNT('Table'[Cliente])/100

     

     


    If it doesn't meet your requirement, Please show the exact expected result based on the Tables that you have shared.


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi Anonymous ,

 

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?


Best regards,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi and thanks for your support. What I want to do is these things all together:

    1) Order by the first column (Agente) in alphabetical order

    2) Order by the third column (2014) in Descending order

    3) Order by the fourth column (2015) in Descending order

    4) Order by the fifth column (2016) in Descending order

    ...and so on until 2019.

    The purpose is to show the highest values first and then the other values in descending order for every Agente. I hope I've explained it in a more understandable way.