I want a Dax query to find the minimum and maximum value of the items

[sonalisaha2310]

I have a list of items, i want a dax quey that can give me the Minimum and the Maximum Count 

Items	Item Count
Apple	1
Orange	1
Grape	1
Apple	1
Watermelon	1
Apple	1
Orange	1
Grape	1
Apple	1

so here the Max count would be apple with count 4 and minimum would be watermelon with count 1

[jay_patel · Accepted solution]

Hi Sonali,

Here's how you can write the DAX expressions for these measures:

Max Count = MAXX(SUMMARIZE('YourTable', 'YourTable'[Items], "Count", COUNT('YourTable'[Items])), [Count])

Min Count = MINX(SUMMARIZE('YourTable', 'YourTable'[Items], "Count", COUNT('YourTable'[Items])), [Count])