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.
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]))
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 |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |