Forum Discussion

DSQU's avatar
DSQU
Helper I
3 years ago

IF Buckets on Aggregate Data

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/3194256

 

Thanks!

 

2 Replies

  • hi DSQU 

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

    • DSQU's avatar
      DSQU
      Helper I

      Thank you- I have confirmed: