Showing top selling product (max of sum)

[bobbyilham]

Pict: https://ibb.co/wBTpsSc

upload image

How to show: Product ID 7146 in the Card Chart as the top selling product, which is max of sum(product_quantity)?
since i can't use MAX(SUM(x))...
My attempt:

MAXX(SUMMARIZE('Order', 'Order'[Product_ID], "Max Quantity", SUM('Order'[Order_Quantity])), [Max Quantity])

[Anonymous]

Why you don't use TOPN on the filter?

topn

[bobbyilham]

yes i can use TOP N, but i won't be able to use CARD CHART for that...

[Anonymous]

Simulate this data and make this expression : 

MAXX(TOPN(1; 'Order'; SUM('Order'[Order_Quantity]);ASC);MAX('Order'[Order_Quantity]))

Result 202

Product_ID	Order_Quantity
7146	201
7736	105
7667	100
7631	95
7158	87
7847	77
8176	77
8188	76
7751	73
7001	69
8179	66
7693	59
7146	202