The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
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
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.
User | Count |
---|---|
158 | |
109 | |
96 | |
83 | |
75 |
User | Count |
---|---|
154 | |
137 | |
131 | |
81 | |
62 |