Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
my dax function for reverse rank is:
Selection | Selected Item | Count of Sessions | Rank | ReverseRank |
Edge Connect Bottom | 2D Webcam | 1 | 6 | 2 |
Edge Connect Bottom | New 2D Barcode Scanner | 1 | 6 | 2 |
Edge Connect Bottom | Small EMV Cradle | 1 | 6 | 2 |
Edge Connect Bottom | 3D Camera | 2 | 5 | 3 |
Edge Connect Bottom | MSR | 3 | 4 | 4 |
Edge Connect Bottom | Fingerprint Scanner | 5 | 3 | 5 |
Edge Connect Bottom | NFC | 9 | 2 | 6 |
Edge Connect Bottom | Status Light | 9 | 2 | 6 |
Edge Connect Bottom | 2D Barcode Scanner | 59 | 1 | 7 |
@wdx223_Daniel ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
@LinhNguyen ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi @wdx223_Daniel , @amitchandak
All of these columns come from the same data table so there should not be any empty row created because of relationships with other tables. I have checked the table this data comes from and there's no blank or empty.
The formula I used for Rank is very similar to Daniel's:
@LinhNguyen , I tried on data given I am getting correct Rank. make sure if you are using a formaul(not measure) in rank then use calculate
use the sample data and code as below, i did not catch that error, all result are normal
Rank:=RANKX(ALL(DataBySelections[Selected Item]),CALCULATE(SUM(DataBySelections[Count of Sessions]),ALLEXCEPT(DataBySelections,DataBySelections[Selected Item])),,DESC,Dense)
*****************************
ReverseRank:=RANKX(ALL(DataBySelections[Selected Item]),[Rank],,DESC,Dense)
i guess you might got a blank item based on a invalid relationship.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |