Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
how to display the user count group by order count?
There are 5 groups for order count as below: 1 , 2, 3-5, 6-10, 11+ , I would like to get user count base on the OrderGroup.
but it always display all user count 9 for the group 11+, but display 0 for other group, who can help check it? is something error in my DAX code?
DAX code for UserCountGroup:
Solved! Go to Solution.
Hi, @tangcy123 ;
Create two measure.
Count = CALCULATE(COUNT('Table'[id]),FILTER(ALL('Table'),[id]=MAX('Table'[id])))
Measure =
CALCULATE(DISTINCTCOUNT('Table'[id]),FILTER('Table',[Count]<=MAX('Group'[Max])&&[Count]>=MAX('Group'[Min])))
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @tangcy123 ;
Create two measure.
Count = CALCULATE(COUNT('Table'[id]),FILTER(ALL('Table'),[id]=MAX('Table'[id])))
Measure =
CALCULATE(DISTINCTCOUNT('Table'[id]),FILTER('Table',[Count]<=MAX('Group'[Max])&&[Count]>=MAX('Group'[Min])))
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@tangcy123 , Are you trying to use this to bucket a measure ? if yes refer
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
97 | |
96 | |
58 | |
45 | |
42 |