Want to count the no of Manager belong to range of bucks.

[SJPB]

Spoiler

Hello Team,

I have data in that Table_X and Table_Y . I want to show count of manger who belong to the range of bucks . Same reference attched in image. so i have made Dax for Emp-headcount ( No of employe work under manger ) and Temp122 ( Bucks catergory of employee) and used in matrix. Still all data showing ok but now i want show bucks category in that >10,1-5 and 6-10 how much emp_headcount came. How i can resolve this issue?

[SJPB]

temp122 = SWITCH(TRUE(),[Emp_Headcount]>0&&[Emp_Headcount]<=5,"1-5",[Emp_Headcount]>5&&[Emp_Headcount]<=10,"6-10",[Emp_Headcount]>10,">10","")

Emp_Headcount = CALCULATE(COUNT(Table_X[Emp No]),'Date'[Date]=MAX(Table_X[Ass Start Date]))

[SJPB]

Emp_Headcount = CALCULATE(COUNT(Table_X[Emp No]),'Date'[Date]=MAX(Table_X[Ass Start Date]))

temp122 = SWITCH(TRUE(),[Emp_Headcount]>0&&[Emp_Headcount]<=5,"1-5",[Emp_Headcount]>5&&[Emp_Headcount]<=10,"6-10",[Emp_Headcount]>10,">10","")

[v-easonf-msft]

Hi, @SJPB 

Can you share the formula of Emp-headcount ?

Please try formula like:

count =
CALCULATE (
    [Emp_Headcount],
    FILTER ( Table_X, Table_X[temp122] = MAX ( Table_Y[Bucks] ) )
)

Best Regards,
Community Support Team _ Eason