https://community.fabric.microsoft.com/t5/Community-Feedback/RANKX-return-wrong-value/m-p/64076#M976 <P>I 'summarize' a table with cost centre and Ytd value. Then I creat a measure:</P><P>Rank = rankx(YtdActualSummary,YtdActualSummary[Ytd Total],1). but the ranking is wrong. Could you please tell me what went wrong? Thanks</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><FONT color="#000000" face="Calibri" size="3">CostCode</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">Ytd Total</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">FinancialYear</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">Rank</FONT></TD></TR><TR><TD><FONT color="#000000" face="Calibri" size="3">104</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">3953</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2017</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2</FONT></TD></TR><TR><TD><FONT color="#000000" face="Calibri" size="3">105</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">17070</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2017</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2</FONT></TD></TR><TR><TD><FONT color="#000000" face="Calibri" size="3">106</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">52270</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2017</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2</FONT></TD></TR><TR><TD><FONT color="#000000" face="Calibri" size="3">107</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">46126</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2017</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2</FONT></TD></TR></TBODY></TABLE> Wed, 31 Aug 2016 10:15:49 GMT Karentang 2016-08-31T10:15:49Z https://community.fabric.microsoft.com/t5/Community-Feedback/RANKX-return-wrong-value/m-p/64076#M976 <P>I 'summarize' a table with cost centre and Ytd value. Then I creat a measure:</P><P>Rank = rankx(YtdActualSummary,YtdActualSummary[Ytd Total],1). but the ranking is wrong. Could you please tell me what went wrong? Thanks</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD><FONT color="#000000" face="Calibri" size="3">CostCode</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">Ytd Total</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">FinancialYear</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">Rank</FONT></TD></TR><TR><TD><FONT color="#000000" face="Calibri" size="3">104</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">3953</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2017</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2</FONT></TD></TR><TR><TD><FONT color="#000000" face="Calibri" size="3">105</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">17070</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2017</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2</FONT></TD></TR><TR><TD><FONT color="#000000" face="Calibri" size="3">106</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">52270</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2017</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2</FONT></TD></TR><TR><TD><FONT color="#000000" face="Calibri" size="3">107</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">46126</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2017</FONT></TD><TD><FONT color="#000000" face="Calibri" size="3">2</FONT></TD></TR></TBODY></TABLE> Wed, 31 Aug 2016 10:15:49 GMT https://community.fabric.microsoft.com/t5/Community-Feedback/RANKX-return-wrong-value/m-p/64076#M976 Karentang 2016-08-31T10:15:49Z