How to create a measure that will filter to different options

[steviehwkns]

Hi All,

I have created the below measure to catergorise different values;

Level = IF(MIN('Table1'[FTE Pay])>=MIN(TierTable[High]),"Above High",IF(MIN('Table1'[FTE Pay])>=MIN(TierTable[Mid]),"Above Mid & Below High",IF(MIN('Table1)>=MIN(TierTable[Entry]),"Above Entry & Below Mid","Below Entry")))

but i need the measure to calculate the number of employees that fall into each category. There is a many to many relationship between the tiertable and table1. This is the kind of result i desire;

Grade	Tier	Category	EmployeeCount
A	1	Above High	15
A	1	Below Entry	12
A	1	Above Entry & Below Mid	3
A	2	Above High	18
A	2	Below Entry	12

The current measure is returning something like this;

Grade	Tier	Category	EmployeeCount
A	1	Above Entry	30

Thank you

[v-kelly-msft]

Hi  @steviehwkns ,

Is your issue solved now？

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[v-kelly-msft]

Hi  @steviehwkns ,

Have you checked my reply?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[v-kelly-msft]

Hi  @steviehwkns,

I have solved a similar issue before,could you pls share your sample with your formular and expected output for test?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[lbendlin]

Please provide sample data and show the data model.