Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |