RANKX starts at 2 instead of 1

[LinhNguyen]

my dax function for reverse rank is: 

ReverseRank = RANKX(all('Data by selections'[Selected Item]),[Rank],,DESC,Dense)

with data as in the table below, the ranks started at 2 instead of 1. I saw a few others having the same issue but none was solved.

Can anyone help me with this? I also tried ALLSELECTED but that didn't work out either.

Thanks

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

[amitchandak]

@wdx223_Daniel ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Appreciate your Kudos.

[amitchandak]

@LinhNguyen ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[LinhNguyen]

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: 

Rank = RANKX(all('Data by selections'[Selected Item]),calculate(count('Data by selections'[SessionID])),,DESC,Dense)

but when I added the 'ALLEXEPT()' part into CALCULATE, the rank started from 32.

Is there anything else this might imply? Anything I can try next to determine what the problem is?

[amitchandak]

@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

[wdx223_Daniel]

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.