cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

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.

3 REPLIES 3
Highlighted
Solution Supplier
Solution Supplier

Hi,

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

Thanks.

Highlighted

Hi,

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

Hope this helps.

 

Sample Data

 

Aparna


Highlighted

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?

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors