Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi - Please help with Ranking in attached pbix..
Ranking is supposed to be: for each SKU by MFG
https://www.dropbox.com/s/8q0d95e5edp5wze/Sample_PBI.pbix?dl=0
TIA
All_In_One_Aug_22 - Google Drive > Look for the page with a name as RANKX , there are multiple pages there
Something similar to this one
@ribisht17
Matching my example with yours.
I have a slicer with Continent, if i choose any single continent then ranking should be only for corresponding countries. The above DAX yields with 1 for all the continents/country/city.
Can you provide a pbix workbook with your example please?
Thanks for the update. How can i not RANK "Supplier 1" in the attached file?
https://www.dropbox.com/s/8q0d95e5edp5wze/Sample_PBI.pbix?dl=0
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |