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
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
Sno | Source |
1 | |
2 | utm source |
3 | utm so |
4 | fsfsf |
5 | test |
6 | D365 |
7 | TestSource |
8 | utm |
9 | abababab |
10 | Dynamics 365 |
11 | SOURCEAG |
12 | D635 |
13 | Staging |
14 | |
15 | e mail |
Solved! Go to Solution.
Hi
can you please check the below link
Might be it helps
Solved: Top 10/Other - Microsoft Fabric Community
Proud to be a 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?
Proud to be a Super User!
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
Proud to be a Super User! | |
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |