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:
Go to Solution.
Hi, @tangcy123 ;
Create two measure.
Count = CALCULATE(COUNT('Table'[id]),FILTER(ALL('Table'),[id]=MAX('Table'[id])))
The final show:
Best Regards,Community Support Team _ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@tangcy123 , Are you trying to use this to bucket a measure ? if yes refer
Dynamic Segmentation Bucketing Binninghttps://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Click here to learn more about the September 2022 updates!
Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!