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 moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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 )
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
90 | |
83 | |
80 | |
49 |
User | Count |
---|---|
146 | |
137 | |
109 | |
68 | |
55 |