Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Categorizing by Revenue

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??

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    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