Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
@Anonymous
Seems like ranking of multi-layers. Please check this:
the codes for the two added columns:
Hi
Column = VAR vCsat = 'Table'[CSAT RANK] RETURN COUNTROWS( FILTER( 'Table', 'Table'[CSAT RANK] = vCsat ) )
Same for CSAT RANK Clean
what issue and data do you have? whe result do you expect?
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
@Anonymous
Seems like ranking of multi-layers. Please check this:
the codes for the two added columns: