Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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])
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])
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |