Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |