Forum Discussion
How to count duplicate records
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
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)RETURNRANKX(Table1,TableName[FW],,ASC)RETURNTableName[CSAT RANK]&"."&FORMAT(CSATRANKClean2,"00")
4 Replies
FreemanZSuper User
what issue and data do you have? whe result do you expect?
- FreemanZ
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)RETURNRANKX(Table1,TableName[FW],,ASC)RETURNTableName[CSAT RANK]&"."&FORMAT(CSATRANKClean2,"00")
- katika555
Resolver I
Hi
Column = VAR vCsat = 'Table'[CSAT RANK] RETURN COUNTROWS( FILTER( 'Table', 'Table'[CSAT RANK] = vCsat ) )
Same for CSAT RANK Clean
