Issues with rankx

Question

Hello. I have 5 product categories and i want to rank them from 1 to 5 according to their sales but the data integrity is not accurate 100% and I would like to ask for some help.

This is my dax function for the Sum:

SumOrders = CALCULATE(IF(ISBLANK(SUM(FactOrders[Total])), 0, SUM(FactOrders[Total])))

Rankx dax:

Sales Amount Product Category Rank =

RANKX ( ALL ( dimProducts[Category_Name]), [SumOrders],, DESC )

Store Rank Text = [Sales Amount Product Category Rank] & " of " & 5

this is the full display of the ranks

when I will pick components and clothing both of them will have rank 3

how can I solve this issue?? Thanks in advance

some_bih · Answer

Hi&nbsp;Anonymous&nbsp;try to replace part ALL in
ALL&nbsp;(&nbsp;dimProducts[Category_Name]) with&nbsp;ALLSELECTED&nbsp;(&nbsp;dimProducts[Category_Name])

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,Based on the information you provided, you can follow this step below:1.Add new measure
&nbsp;
Sales Amount Product Category Rank = 
RANKX (
    FILTER ( ALL ( 'Table' ), 'Table'[orders] ),
    CALCULATE ( MAX ( 'Table'[orders] ) ),
    ,
    DESC
)
Store Rank Text = 
[Sales Amount Product Category Rank] &amp; " of " &amp; 5

&nbsp;
&nbsp;
Final output:
&nbsp;

&nbsp;
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired out put and pbix file without privacy information.
&nbsp;
Best Regards,
Ada Wang
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

anonymous · Answer

it helps but for some reason i dont know how to adjust my table for your solution
I dont know how to upload the file ... I am new to this platform

https://app.powerbi.com/groups/b19193eb-e902-4d4f-8151-d6dba74e6c6d/reports/017d5641-90c5-47bb-a0ff-bb8078fe69a6/ReportSection?experience=power-bi

i hope this help somehow.

anonymous · Answer

unfortunately didnt help, it ranks every category as 1

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
You can put your files in a dropbox, onedrive or googledrive folder and share the link with the community. Please provide more details with your desired out put and pbix file without privacy information.
&nbsp;
Please refer to the related links for details:
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
How to Get Your Question Answered Quickly - Microsoft Fabric Community
&nbsp;
Best Regards,
Ada Wang

Forum Discussion

Issues with rankx

6 Replies

Related content

RankX

RANKX ISSUES

RANKX issue

Rankx Issue

RANKX issue