topic How to sum rounded up rows in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-rounded-up-rows/m-p/993024#M12374 <P>Hi guys, I am facing a problem,&nbsp;</P><P>&nbsp;</P><P>imagine, I have&nbsp; following table:</P><TABLE border="1"><TBODY><TR><TD>Value (calculated as a measure)</TD><TD>Rounded up value (calculated as a measure)</TD></TR><TR><TD>1,2</TD><TD>2</TD></TR><TR><TD>1,5</TD><TD>2</TD></TR><TR><TD>2,1</TD><TD>3</TD></TR></TBODY></TABLE><P>Now I need to calculate sum of the rounded-up values, which would give me 7. However, all I get from Power BI is always 5. (it sums up Value and then it rounds it up....</P><P><BR />Any advice? Cheers.</P> Thu, 26 Mar 2020 09:49:23 GMT zenisekd 2020-03-26T09:49:23Z How to sum rounded up rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-rounded-up-rows/m-p/993024#M12374 <P>Hi guys, I am facing a problem,&nbsp;</P><P>&nbsp;</P><P>imagine, I have&nbsp; following table:</P><TABLE border="1"><TBODY><TR><TD>Value (calculated as a measure)</TD><TD>Rounded up value (calculated as a measure)</TD></TR><TR><TD>1,2</TD><TD>2</TD></TR><TR><TD>1,5</TD><TD>2</TD></TR><TR><TD>2,1</TD><TD>3</TD></TR></TBODY></TABLE><P>Now I need to calculate sum of the rounded-up values, which would give me 7. However, all I get from Power BI is always 5. (it sums up Value and then it rounds it up....</P><P><BR />Any advice? Cheers.</P> Thu, 26 Mar 2020 09:49:23 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-rounded-up-rows/m-p/993024#M12374 zenisekd 2020-03-26T09:49:23Z Re: How to sum rounded up rows https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-rounded-up-rows/m-p/993181#M12376 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="187376" data-lia-user-login="zenisekd" class="lia-mention lia-mention-user">zenisekd</a>&nbsp;</P> <P>try SUMX()</P> <LI-CODE lang="markup">= SUMX(Table, ROUNDUP(Table[Value]))</LI-CODE> Thu, 26 Mar 2020 11:24:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/How-to-sum-rounded-up-rows/m-p/993181#M12376 az38 2020-03-26T11:24:46Z