Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |