topic How to calculate percentage ranking in Desktop
https://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2086100#M775904
<TABLE><TBODY><TR><TD>Date</TD><TD>Category</TD><TD>1DaySales</TD><TD>Rank</TD><TD>percent rank</TD></TR><TR><TD>4/6/2021</TD><TD>Equity</TD><TD>123</TD><TD>4</TD><TD>100</TD></TR><TR><TD>4/6/2021</TD><TD>Equity</TD><TD>345</TD><TD>3</TD><TD>75</TD></TR><TR><TD>4/6/2021</TD><TD>Equity</TD><TD>567</TD><TD>2</TD><TD>50</TD></TR><TR><TD>4/6/2021</TD><TD>Equity</TD><TD>789</TD><TD>1</TD><TD>25</TD></TR><TR><TD>4/6/2021</TD><TD>Commodity</TD><TD>453</TD><TD>2</TD><TD>100</TD></TR><TR><TD>4/6/2021</TD><TD>Commodity</TD><TD>564</TD><TD>1</TD><TD>50</TD></TR><TR><TD>4/6/2021</TD><TD>Currency</TD><TD>234</TD><TD>1</TD><TD>100</TD></TR><TR><TD>4/5/2021</TD><TD>Equity</TD><TD>256</TD><TD>3</TD><TD>75</TD></TR><TR><TD>4/5/2021</TD><TD>Equity</TD><TD>0</TD><TD>4</TD><TD>100</TD></TR><TR><TD>4/5/2021</TD><TD>Equity</TD><TD>345</TD><TD>2</TD><TD>50</TD></TR><TR><TD>4/5/2021</TD><TD>Equity</TD><TD>754</TD><TD>1</TD><TD>25</TD></TR><TR><TD>4/5/2021</TD><TD>Commodity</TD><TD>683</TD><TD>1</TD><TD>100</TD></TR><TR><TD>4/5/2021</TD><TD>Commodity</TD><TD>null</TD><TD> </TD><TD> </TD></TR><TR><TD>4/5/2021</TD><TD>Currency</TD><TD>246</TD><TD>3</TD><TD>300</TD></TR></TBODY></TABLE><P><BR />I want to calculate rank and percent rank<BR /><BR />In report i have slicer Date, Category <BR /><BR />Ranking is based on 1daysales by the selection of date and category <BR />percent rank forumula= ranking*100/counta(1daysales)<BR /><BR />Note :- if its blank dont assign rank and percent rank<BR /><BR /><BR /></P>Mon, 20 Sep 2021 10:42:25 GMTAnshenterprices2021-09-20T10:42:25ZHow to calculate percentage ranking
https://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2086100#M775904
<TABLE><TBODY><TR><TD>Date</TD><TD>Category</TD><TD>1DaySales</TD><TD>Rank</TD><TD>percent rank</TD></TR><TR><TD>4/6/2021</TD><TD>Equity</TD><TD>123</TD><TD>4</TD><TD>100</TD></TR><TR><TD>4/6/2021</TD><TD>Equity</TD><TD>345</TD><TD>3</TD><TD>75</TD></TR><TR><TD>4/6/2021</TD><TD>Equity</TD><TD>567</TD><TD>2</TD><TD>50</TD></TR><TR><TD>4/6/2021</TD><TD>Equity</TD><TD>789</TD><TD>1</TD><TD>25</TD></TR><TR><TD>4/6/2021</TD><TD>Commodity</TD><TD>453</TD><TD>2</TD><TD>100</TD></TR><TR><TD>4/6/2021</TD><TD>Commodity</TD><TD>564</TD><TD>1</TD><TD>50</TD></TR><TR><TD>4/6/2021</TD><TD>Currency</TD><TD>234</TD><TD>1</TD><TD>100</TD></TR><TR><TD>4/5/2021</TD><TD>Equity</TD><TD>256</TD><TD>3</TD><TD>75</TD></TR><TR><TD>4/5/2021</TD><TD>Equity</TD><TD>0</TD><TD>4</TD><TD>100</TD></TR><TR><TD>4/5/2021</TD><TD>Equity</TD><TD>345</TD><TD>2</TD><TD>50</TD></TR><TR><TD>4/5/2021</TD><TD>Equity</TD><TD>754</TD><TD>1</TD><TD>25</TD></TR><TR><TD>4/5/2021</TD><TD>Commodity</TD><TD>683</TD><TD>1</TD><TD>100</TD></TR><TR><TD>4/5/2021</TD><TD>Commodity</TD><TD>null</TD><TD> </TD><TD> </TD></TR><TR><TD>4/5/2021</TD><TD>Currency</TD><TD>246</TD><TD>3</TD><TD>300</TD></TR></TBODY></TABLE><P><BR />I want to calculate rank and percent rank<BR /><BR />In report i have slicer Date, Category <BR /><BR />Ranking is based on 1daysales by the selection of date and category <BR />percent rank forumula= ranking*100/counta(1daysales)<BR /><BR />Note :- if its blank dont assign rank and percent rank<BR /><BR /><BR /></P>Mon, 20 Sep 2021 10:42:25 GMThttps://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2086100#M775904Anshenterprices2021-09-20T10:42:25ZRe: How to calculate percentage ranking
https://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2086156#M775917
<P><LI-USER uid="305700"></LI-USER> , Create two measures like</P>
<P> </P>
<P><BR />Rank = rankx(filter(allselected(Table[DAte], Table[Category]), [Category] =max([category]) ), calculate(sum(table[1DaySales])))</P>
<P>count Day = calculate(count(Table[Date]), filter(allselected(Table), Table[Date] = max(Table[Date]) && Table[category] = max(Table[category]) ))</P>
<P> </P>
<P> </P>
<P>and then %</P>
<P>% = divide([Rank], [count day])</P>Mon, 20 Sep 2021 11:31:55 GMThttps://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2086156#M775917amitchandak2021-09-20T11:31:55ZRe: How to calculate percentage ranking
https://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2086494#M776006
<P><LI-USER uid="148838"></LI-USER> thank you<BR />forgot to mentioned in the post, In a table there is also one column i.e. online/offline category , <BR />I have used online/offline category as a Slicer in the report,but dont want seperate raking and percent rank once i select online or offline category. it should be same in both ways</P>Mon, 20 Sep 2021 14:14:28 GMThttps://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2086494#M776006Anshenterprices2021-09-20T14:14:28ZRe: How to calculate percentage ranking
https://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2088616#M776538
<P><LI-USER uid="148838"></LI-USER> Thank you so much</P>Tue, 21 Sep 2021 11:48:07 GMThttps://community.powerbi.com/t5/Desktop/How-to-calculate-percentage-ranking/m-p/2088616#M776538Anshenterprices2021-09-21T11:48:07Z