Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
111 | |
96 | |
96 | |
67 | |
63 |