To find the top 3 comments in the column and to display the same in three different columns

[aparnavjyn]

Hi,

I have a set of Comment categories for various productgroups. I need to find the top 3 most repeated comment category for the Survey year "2019" and display it as a part of a matrix. Any help is appreciated. Thanks in advance.

[Anonymous]

Hi,

If you could share some sample data and the expected resut that would help.

Thanks.

[aparnavjyn]

This formula helped me in getting the top most occuring value. But unable to modify the formula for the 2nd and top occuring values. 

Top_First ActionItem = CALCULATE(FIRSTNONBLANK(

TOPN(

1,

(VALUES(DB_CX_2018_V6_V2_New[Action Items])),

RANKX(ALL(DB_CX_2018_V6_V2_New[Action Items]),[Count_Action Items],,ASC)),1),FILTER(DB_CX_2018_V6_V2_New,DB_CX_2018_V6_V2_New[Survey_Year]="2019"))

Any suggestions?

[aparnavjyn]

Hi,

Please find the attached sample data. Tab1 contains Data Sample and Tab 2 contains the Required result.

Hope this helps.

Sample Data

Aparna

---