IF Buckets on Aggregate Data

[DSQU]

My question in the other forum didn't get much traction. I just noticed this DAX specific forum so i figured I would try a simpler question here: 

Why does the IF statement not assign a 2 value for the first row, which is under 3,000,000? I am trying to create buckets based on aggregate data. 

The detailed data/table looks like this. The IF statement works fine on non-aggregated data: 

Original more complex version of the question: 

https://community.powerbi.com/t5/Desktop/Row-Groupings-for-Measure-Not-Showing-As-Expected/m-p/31942...

Thanks!

[FreemanZ]

hi @DSQU 

in your first screenshot, please ensure Account Num is in the column field of the table visual. 

[DSQU]

Thank you- I have confirmed: