Add Ranking in a summarized table, but duplicated.

Question

&nbsp; Hi.&nbsp;I made a summarized table with the following dax. However, there are some duplicated rankings even if the values are not similar.Can you help me to solve the problem?&nbsp;Ranking - Region = VAR _month = MONTH(TODAY())VAR _year = YEAR(TODAY())VAR _RefYear = IF(_month &gt; 6, _year, _year - 1)RETURNADDCOLUMNS(&nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '_SALES',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (YEAR('_SALES'[Transaction Date]) = _RefYear &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RELATED(_CUSTOMER[Division Code]) IN {"1", "2", "3"} &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RELATED(_GROUP[Product Group Code]) = "A") &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '_SALES'[USD] &gt; 0&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; _CUSTOMER[Region Index],&nbsp; &nbsp; &nbsp; &nbsp; "Sales", SUM('_SALES'[USD]),&nbsp; &nbsp; &nbsp; &nbsp; "Year", _RefYear&nbsp; &nbsp; ),&nbsp; &nbsp; "Region Rank",&nbsp; &nbsp; RANKX(&nbsp; &nbsp; &nbsp; &nbsp; SUMMARIZE(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '_SALES',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (YEAR('_SALES'[Transaction Date]) = _RefYear &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RELATED(_CUSTOMER[Division Code]) IN {"1", "2", "3"} &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RELATED(_GROUP[Product Group Code]) = "A") &amp;&amp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; '_SALES DATA'[USD] &gt; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; _CUSTOMER[Region Index],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Sales", SUM('_SALES DATA'[USD])&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; [Sales],&nbsp; &nbsp; &nbsp; &nbsp; ,&nbsp; &nbsp; &nbsp; &nbsp; DESC,&nbsp; &nbsp; &nbsp; &nbsp; DENSE&nbsp; &nbsp; ))&nbsp;Region Index is a unique value in text.Example result,&nbsp;Region Index&nbsp; &nbsp;Ranking&nbsp; SalesA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4541889.2B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4681260.92&nbsp;I don't think the A and B regions are the same ranking.Please help me to solve this problem.

anonymous · Accepted Answer

Hi&nbsp;Young_G_Han&nbsp;,&nbsp;Please share sample data in one drive and paste the link here to explore further.&nbsp;Cheers&nbsp;CheenuSing

Forum Discussion

Add Ranking in a summarized table, but duplicated.

2 Replies

Related content

Duplicate ranking

Why rankx function shows duplicated rank?

RANKX Formula Returning Duplicate Ranks

Remove Duplicate Ranking

Parameter in summarize