https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Buckets-on-Aggregate-Data/m-p/3207448#M116852 <P>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:&nbsp;</P><P>&nbsp;</P><P>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.&nbsp;</P><P><img /></P><P>&nbsp;</P><P>The detailed data/table looks like this. The IF statement works fine on non-aggregated data:&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Original more complex version of the question:&nbsp;</P><P><A href="https://community.powerbi.com/t5/Desktop/Row-Groupings-for-Measure-Not-Showing-As-Expected/m-p/3194256" target="_blank">https://community.powerbi.com/t5/Desktop/Row-Groupings-for-Measure-Not-Showing-As-Expected/m-p/3194256</A></P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P> Wed, 26 Apr 2023 14:07:12 GMT DSQU 2023-04-26T14:07:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Buckets-on-Aggregate-Data/m-p/3207448#M116852 <P>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:&nbsp;</P><P>&nbsp;</P><P>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.&nbsp;</P><P><img /></P><P>&nbsp;</P><P>The detailed data/table looks like this. The IF statement works fine on non-aggregated data:&nbsp;</P><P><img /></P><P>&nbsp;</P><P>&nbsp;</P><P>Original more complex version of the question:&nbsp;</P><P><A href="https://community.powerbi.com/t5/Desktop/Row-Groupings-for-Measure-Not-Showing-As-Expected/m-p/3194256" target="_blank">https://community.powerbi.com/t5/Desktop/Row-Groupings-for-Measure-Not-Showing-As-Expected/m-p/3194256</A></P><P>&nbsp;</P><P>Thanks!</P><P>&nbsp;</P> Wed, 26 Apr 2023 14:07:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Buckets-on-Aggregate-Data/m-p/3207448#M116852 DSQU 2023-04-26T14:07:12Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Buckets-on-Aggregate-Data/m-p/3207521#M116860 <P>hi <a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="546314" data-lia-user-login="DSQU" class="lia-mention lia-mention-user">DSQU</a>&nbsp;</P><P>in your first screenshot, please ensure Account Num is in the column field of the table visual.&nbsp;</P> Wed, 26 Apr 2023 14:42:35 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Buckets-on-Aggregate-Data/m-p/3207521#M116860 FreemanZ 2023-04-26T14:42:35Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Buckets-on-Aggregate-Data/m-p/3207530#M116861 <P>Thank you- I have confirmed:&nbsp;</P><P><img /></P><P>&nbsp;</P> Wed, 26 Apr 2023 14:46:49 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/IF-Buckets-on-Aggregate-Data/m-p/3207530#M116861 DSQU 2023-04-26T14:46:49Z