How to display the user count correctly group by order count?

[tangcy123]

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:

UserCount =

IF(ISFILTERED('OrderGroup'[OrderGroup]),

CALCULATE(

DISTINCTCOUNT('Order'[userid_id]),

FILTER('Order',

AND(

COUNT('Order'[order_no]) <=SELECTEDVALUE('OrderGroup'[Max]),

COUNT('Order'[order_no]) >=SELECTEDVALUE(OrderGroup[Min])

)

)

),

DISTINCTCOUNT('Order'[userid_id] )

) + 0

[v-yalanwu-msft · Accepted 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.

[amitchandak]

@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