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.
Hello.
This seems to be a very easy DAX but somehow I haven't found the solution.
Here's a copy of a table I am working on:
I just need to count the number of customers who purchased more than 1 unit. The answer should be 6 in the example above. But, the total is currently summing all the customers which is 13. I tried various fashions of sumx and couldn't get anything closer than the if formula.
Any hints?
Thanks.
Solved! Go to Solution.
Hi @etane
Would a measure like this help?
Customers who bought multiple units =
COUNTROWS(
FILTER(
SUMMARIZE(
'Table',
'Table'[Accounts],
"_Units",
SUM( 'Table'[Units Sold] )
),
[_Units] > 1
)
)
Let me know if you have any questions.
(In the model I added DimAccount so I could fix the sort order.)
Hi @etane
Would a measure like this help?
Customers who bought multiple units =
COUNTROWS(
FILTER(
SUMMARIZE(
'Table',
'Table'[Accounts],
"_Units",
SUM( 'Table'[Units Sold] )
),
[_Units] > 1
)
)
Let me know if you have any questions.
(In the model I added DimAccount so I could fix the sort order.)
Another option is calculate(distinctcount('Table'[Accounts]), 'Table'[Units Sold] > 1)
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
58 | |
29 | |
21 | |
16 |