card with top product by sales

[mikem986]

There is likely a simple solution to this but I cant seem to find it. I'd like to create a card that shows which product is the highest selling based on sales quantity. 

For example

Transaction number	Product	Units Sold
1	Toy	2
2	Snack	4
3	Toy	3
4	Beverage	1
5	Snack	5

In this case, id like to have a card that shows "Snack" given that in this table it has the largest quantity sold.

I'd also like to do the reverse, a card that shows the lowest selling product, so "Beverage"

[ryan_mayu · Accepted solution]

@mikem986 

pls try this

Measure = 
VAR tbl=SUMMARIZE('Table','Table'[Product],"_sum",sum('Table'[Units Sold]))
VAR _max=maxx(tbl,[_sum])
return maxx(FILTER(tbl,_max=[_sum]),'Table'[Product])

Measure2 = 
VAR tbl=SUMMARIZE('Table','Table'[Product],"_sum",sum('Table'[Units Sold]))
VAR _min=minx(tbl,[_sum])
return maxx(FILTER(tbl,_min=[_sum]),'Table'[Product])