Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I'm trying to get the top 10 occurrences of a column (see below)
The format is text.
Ideally, I would like to get the following result:
In this example, Laptop = "5242" and Windows User Profile = "5003"
Thx in advance
Regards
Julien
Solved! Go to Solution.
Hi @Noexicaise ,
For your issue, maybe you can do like this:
//create a column in the original table; the Sales[Brand]field is the counted column
Number =
CALCULATE(
COUNT(Sales[Brand]),
ALLEXCEPT(
Sales, Sales[Brand]
)
)
// return the count table
Count_occurence =
TOPN(
10,
DISTINCT(Sales),
Sales[Number],
ASC
)
Best Regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Noexicaise ,
For your issue, maybe you can do like this:
//create a column in the original table; the Sales[Brand]field is the counted column
Number =
CALCULATE(
COUNT(Sales[Brand]),
ALLEXCEPT(
Sales, Sales[Brand]
)
)
// return the count table
Count_occurence =
TOPN(
10,
DISTINCT(Sales),
Sales[Number],
ASC
)
Best Regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Do you have a table with columns showing you which number goes with what name? Like:
Name | Number |
Laptop | 5242 |
If so, you can use a table visual adding 2 columns, one column shows you the "Name" and the other column shows you "Count of Name". You might have to add some relationships if you have more than 1 table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |