Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello Everyone
I am new at Power BI , and I have problem here in getting the correct Rankx
appreciate if anyone could help me out .
I have three tables
1, Statistics Table
product | period | volume |
Apple | Jan | 320 |
Apple | Feb | 650 |
Orange | Jan | 110 |
Orange | Feb | 890 |
Pear | Jan | 300 |
Pear | Feb | 400 |
Banana | Jan | 550 |
Banana | Feb | 300 |
2000 | Jan | 400 |
2000 | Feb | 900 |
2, BridgeTable
Product |
apple |
orange |
pear |
banana |
2000 |
3,BOM table
component | product | qty |
1001 | apple | 1 |
1002 | apple | 2 |
1003 | apple | 3 |
1001 | orange | 1 |
1003 | orange | 6 |
1001 | pear | 1 |
1002 | pear | 8 |
1003 | banana | 2 |
1002 | banana | 4 |
2000 | 2000 | 1 |
the Measure I used RANKX(Statistics;[Component Volume];;ASC) , but the result is not correct as below picture , any clue ?? thanks
Solved! Go to Solution.
Try this one
rank = RANKX ( ALLSELECTED ( Bridgetable[product] ), [Component Volume],, ASC, DENSE )
If you donot want to rank the BLANKS..then
rank2 = VAR myrank = RANKX ( FILTER ( ALLSELECTED ( Bridgetable[product] ), [Component Volume] <> BLANK () ), [Component Volume], , ASC, DENSE ) RETURN IF ( NOT ( ISBLANK ( [Component Volume] ) ), myrank )
May be
= RANKX ( ALLSELECTED ( Statistics[product] ), [Component Volume],, ASC )
Could you share your file via onedrive or googledrive?
please check if you could reach it via the link
https://drive.google.com/file/d/1LSNQy8UgbOkHsIVjMCOJtMrkzZPkJWxu/view?usp=sharing
Please See file attached
Try this one
rank = RANKX ( ALLSELECTED ( Bridgetable[product] ), [Component Volume],, ASC, DENSE )
If you donot want to rank the BLANKS..then
rank2 = VAR myrank = RANKX ( FILTER ( ALLSELECTED ( Bridgetable[product] ), [Component Volume] <> BLANK () ), [Component Volume], , ASC, DENSE ) RETURN IF ( NOT ( ISBLANK ( [Component Volume] ) ), myrank )
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
86 | |
85 | |
67 | |
49 |
User | Count |
---|---|
139 | |
113 | |
104 | |
64 | |
60 |