Calculate max of count in DirectQuery mode

[jppv20]

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.

[amitchandak · Accepted 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]))