Forum Discussion

zenisekd's avatar
zenisekd
Super User
6 years ago
Solved

How to sum rounded up rows

Hi guys, I am facing a problem, 

 

imagine, I have  following table:

Value (calculated as a measure)Rounded up value (calculated as a measure)
1,22
1,52
2,13

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....


Any advice? Cheers.

1 Reply

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi zenisekd 

    try SUMX()

    = SUMX(Table, ROUNDUP(Table[Value]))