Rank Percentage in Power BI

Question

Hi,&nbsp;I have a question regarding the ranking of Percentage. I have the following table:GoodsManagerPercentageBedManager 194.87%TableManager 294.79%TableManager 382%ChairManager 179%&nbsp;I need another column showing the rankings. In the sense, it should look like the following:GoodsManagerPercentageRankingBedManager 194.87%1TableManager 294.79%2TableManager 382%3&nbsp;&nbsp;&nbsp;&nbsp;I tried my best,&nbsp; but nothing was just happening. It shows all rankings as "1". I calculated the percentages with the help of a measure. The measure is: Percentage = 'Main Data'[Net Sales]/[Gross Sales].&nbsp;

anonymous · Answer

Hi, I dont know how the digits have got shifted. Its Actually |Manager 1|&nbsp; |94.87%|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |Manager 2||&nbsp; |94.79%|&nbsp;and so on....

tackytechtom · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
How about this:

&nbsp;
&nbsp;
Here the DAX for the ranking measure.&nbsp;
RankingMeasure = 
RANKX(
    ALLSELECTED ( 'Main Data' ),
    [PercentageMeasure], 
    , DESC
    , DENSE 
)
&nbsp;
I took the snippet from here.
&nbsp;
Let me know if this helps 🙂
&nbsp;
/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/

anonymous · Answer

Hi, No it still didnt work. Dont know how did you get this. but I am not able to get it.&nbsp;

tackytechtom · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Is this one a measure or a calculated column?

/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/
&nbsp;

anonymous · Answer

it is a measure

Forum Discussion

Rank Percentage in Power BI

6 Replies

Related content

Duplicate ranking

Ranking KPI card

Dynamic Ranking

Rank with conditions

What are community ranks?

Goods	Manager	Percentage
Bed	Manager 1	94.87%
Table	Manager 2	94.79%
Table	Manager 3	82%
Chair	Manager 1	79%