Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Conditional group for top 10 and others with category field

Dear all,

 

Need suggestion based on the below field name: Source

Field name with source info need to categorized top 10 distinct count as one condition High and others as Low including blank too

 

Please suggest how can we achieve this? Much helpful

 

SnoSource
1 
2utm source
3utm so
4fsfsf
5test
6D365
7TestSource
8utm
9abababab
10Dynamics 365
11SOURCEAG
12D635
13Staging
14linkedin
15e mail

 

1 ACCEPTED SOLUTION

Hi 

 

can you please check the below link 

 

Might be it helps

Solved: Top 10/Other - Microsoft Fabric Community





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

what's the expected output for this? I didn't see any duplicated values int the sample data.

 

what if we have the same distinct count result? how to select top 10?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Hi @ryan_mayu Thanks for the response

I have shared the unique informaiton but in source details level have duplicates too,

based on the souce field, need to generate a column with top 10 + Others .

 

Please suggest, if any

Hi 

 

can you please check the below link 

 

Might be it helps

Solved: Top 10/Other - Microsoft Fabric Community





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.