Forum Discussion

RealTrentG's avatar
RealTrentG
Frequent Visitor
1 year ago
Solved

Power BI roundup not calculating correctly

Trying to use the ROUNDUP function to round a column I created in a table, but it is not rounding properly in all cases.  The 'PEOPLE REQD' column is just the 'PIECES' column divided by 3,000, no pro...
Need Help
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi RealTrentG ,

    Thank you for reaching out to Microsoft Community.
    I hope the below measure works as per your requirement.

    MERCH REQD = ROUNDUP(SUM('Table (2)'[PIECES]) / 3000, 0)

    If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

    Thanks,
    Chaithra E.



RealTrentG's avatar
RealTrentG
Frequent Visitor
1 year ago

Not exactly.  I want so sum the pieces first and then calculate the MERCH REQD.  In this example, it works out that I should end up with 3.00 since 7,793/3,000 = 2.6, which rounds up to 3.00.  But in the scenario below, if I use the MAX function I would end up with 3.00 MERCH REQD, but I should have 5.00 based on the Total PIECES of 12,500 (12,500/3,000 = 4.17, roundup to 5.00)

TypePIECESDivide 3,000Roundup/MERCH REQD
A             8,0002.673.00 
B             4,5001.502.00 
TOTAL          12,5004.175.00 

 

Thanks again

Irwan's avatar
Irwan
Icon for Super User rankSuper User
1 year ago

hello RealTrentG 

 

i am confused.

 

based on your previous post, i assumed you want to get the max value then use MAX.

if you want to get sum, then use sum.

Total calculation in table is based on what function you are using.

 

using ROUND() to round closest value

 

using ROUNDUP() to roundup closest value.

 

Thank you.