Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I'm using DirectQuery mode and have a table like this:
Id | Product |
1 | Product 1 |
2 | Product 1 |
3 | Product 2 |
4 | Product 2 |
5 | Product 1 |
6 | Product 3 |
7 | Product 2 |
8 | Product 1 |
9 | Product 3 |
10 | Product 4 |
Using a measure I need to count the sales of the product which is sold the most. In this example the measure output should be 4.
Hope someone can help.
Thanks in advance.
Solved! Go to Solution.
@jppv20 , Try a measure like
Top 1= calculate(max(Table[Product]),TOPN(1,allselected(table[product]),calculate(count(Table[Id])),DESC), values(table[product]))
@jppv20 , Try a measure like
Top 1= calculate(max(Table[Product]),TOPN(1,allselected(table[product]),calculate(count(Table[Id])),DESC), values(table[product]))
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |