Count data

[Naveennegi119]

Hi All,

I want to count in sequence but using many dax or create new column i get duplicate sequence no. in duplicate data see Below:-

 I want count see below:-

Regards,

NICK

[Zubair_Muhammad · Accepted solution]

Hi @Naveennegi119

First add an Index Column in your Table from the Query Editor >>"Add Column" tab

Then you can use this formula

Expected Situation 1 =
RANKX (
    FILTER ( Table1, Table1[Sub] = EARLIER ( Table1[Sub] ) ),
    Table1[Value]
        - Table1[Index] / 1000,
    ,
    DESC,
    DENSE
)

[Zubair_Muhammad · Accepted solution]

@Naveennegi119

And this for expected situation 2

Expected Situation 2 =
RANKX ( Table1, Table1[Value] - Table1[Index] / 1000,, DESC, DENSE )

[Naveennegi119]

Hi All,

I think right now there is no solution of this situation.

That's why no body answering.

regards,

NICK

[Zubair_Muhammad · Accepted solution]

Hi @Naveennegi119

First add an Index Column in your Table from the Query Editor >>"Add Column" tab

Then you can use this formula

Expected Situation 1 =
RANKX (
    FILTER ( Table1, Table1[Sub] = EARLIER ( Table1[Sub] ) ),
    Table1[Value]
        - Table1[Index] / 1000,
    ,
    DESC,
    DENSE
)

[Zubair_Muhammad · Accepted solution]

@Naveennegi119

And this for expected situation 2

Expected Situation 2 =
RANKX ( Table1, Table1[Value] - Table1[Index] / 1000,, DESC, DENSE )

[Zubair_Muhammad · Accepted solution]

@Naveennegi119

Please see attached sample file as well

[Naveennegi119]

Hi @Zubair_Muhammad,

Thanks for sharing idea,

it's working fine for me,

Regards,

NICK