Categorizing by Revenue

[Anonymous]

I am attempting to place people into different $ ranges. I first have a formula that sums what they made in a year:

Using that formula, I then made this formula to categorize:

But then the results are right for some, and wrong for others. I don't understand why:

Does anybody know why this is happening or know of a better way to do this??

[v-lili6-msft]

hi, @Anonymous 

I have tested on my side, but not reproduce the issue.

Could you share your sample pbix file and expected output for us?

Best Regards,

Lin