calculate RANK

[Anonymous]

hello Guys
i want to calculate the rank in power bi 
below is my Datset

count FW	CSAT
12	1
1	1
21	2
17	2
14	3
19	3
12	3

 I want to calculate CSAT RANK and CSAT RANK Final 
expected Result is 

FW	CSAT	CSAT RANK	CSAT RANK FINAL
12	1	1	1.01
1	1	1	1.02
21	2	2	2.01
17	2	2	2.02
14	32	3	3.01
19	32	3	3.02
12	32	3	3.03

 Plz Help how to Calculate CSAT RANK and CSAT RANK Clean

Thanks
pardnya 137

[FreemanZ]

Seems like ranking of multi-layers. Please check this:

the codes for the two added columns:

CSAT RANK =

RANKX(

    ALL(TableName),

    TableName[CSAT],

    ,

    ASC,

    Dense

)

CSAT RANK Clean =

VAR  CSATRANKClean2 =

    VAR CurrentCSAT = TableName[CSAT]

    VAR Table1 =

    FILTER(

        TableName,

        TableName[CSAT] = CurrentCSAT

    )

    RETURN

        RANKX(

        Table1,

        TableName[FW],

        ,

        ASC

    )

RETURN

    TableName[CSAT RANK]&"."&FORMAT(CSATRANKClean2,"00")

same topic?

[amitchandak]

@Anonymous , Based on what I got

Create a new rank column

CSAT Rank  = Rankx(Table, [CSAT],,asc, dense)

and a new column

CSAT final  Rank = [CSAT Rank]+ [CSAT Rank]/100

[Anonymous]

Thanks of reply @amitchandak 
CSAT RANK is correct we can use RANKX function but 
CSAT RANK Final is not i want to calculate the rank final like when the rank is Repeated it should be increment by 0.01..I want below result of CSAT Rank Clean.. Please Help..

CSAT RANK	CSAT RANK Clean
1	1.01
1	1.02
1	1.03
1	1.04
1	1.05

Thanks
pradnya

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You need to add a column of index to the Power Query.

Column:

CSAT Rank = RANKX('Table',[CSAT],,ASC, dense)

Column = 
CALCULATE (
    COUNT ( 'Table'[CSAT] ),
    FILTER (
        'Table',
        [CSAT] = EARLIER ( 'Table'[CSAT] )
            && [Index] <= EARLIER ( 'Table'[Index] )
    )
)

CSAT RANK FINAL = [CSAT Rank]+[Column]*0.01

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.