Forum Discussion
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...
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,
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,