topic Re: To find the top 3 comments in the column and to display the same in three different columns in DAX Commands and Tips

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

aparnavjyn — Mon, 14 Oct 2019 04:45:23 GMT

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.

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

Anonymous — Mon, 14 Oct 2019 06:11:38 GMT

Hi,

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

Thanks.

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

aparnavjyn — Mon, 14 Oct 2019 06:29:04 GMT

Hi,

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

Hope this helps.

Sample Data

Aparna

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

aparnavjyn — Tue, 15 Oct 2019 10:26:22 GMT

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(

(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?