How to count duplicate records

[Anonymous]

Hello Guys..
i want to calculate CSAT RANK and CSAT RANK Clean Measure in Power bi
plz refer below sample Table

FW	Csat	CSAT RANK	CSAT RANK Clean
12	1	1	1.01
10	2	2	2.01
11	12	3	3.01
19	12	3	3.02
16	2	2	2.02

please help
Thanks
pradnya137

[katika555]

Hi  

Column = VAR vCsat = 'Table'[CSAT RANK] RETURN COUNTROWS( FILTER( 'Table', 'Table'[CSAT RANK] = vCsat ) )

Same for CSAT RANK Clean

[FreemanZ]

what issue and data do you have? whe result do you expect?

[Anonymous]

i want to calculate CSAT RANK and CSAT RANK CLEAN based of CSAT column the result what i want is shown in above table..
plz help

[FreemanZ · Accepted solution]

@Anonymous 

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")