March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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:
when I will pick components and clothing both of them will have rank 3
how can I solve this issue?? Thanks in advance
Hi @Anonymous ,
Based on the information you provided, you can follow this step below:
1.Add new measure
Sales Amount Product Category Rank =
RANKX (
FILTER ( ALL ( 'Table' ), 'Table'[orders] ),
CALCULATE ( MAX ( 'Table'[orders] ) ),
,
DESC
)
Store Rank Text =
[Sales Amount Product Category Rank] & " of " & 5
Final output:
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.
Best Regards,
Ada Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
i hope this help somehow.
Hi @Anonymous ,
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.
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
Best Regards,
Ada Wang
its 119000 records so I cant do the sample data option
this is the file via my google drive:
https://drive.google.com/file/d/1BnhIMW-kr5ZTIXw49ga2gLCakG1MWB5_/view?usp=drive_link
Hi @Anonymous try to replace part ALL in
ALL ( dimProducts[Category_Name]) with ALLSELECTED ( dimProducts[Category_Name])
Proud to be a Super User!
unfortunately didnt help, it ranks every category as 1
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
26 | |
16 | |
15 | |
12 | |
11 |
User | Count |
---|---|
32 | |
26 | |
24 | |
20 | |
14 |