How to sum rounded up rows

[zenisekd]

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,2	2
1,5	2
2,1	3

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.

[az38 · Accepted solution]

Hi @zenisekd 

try SUMX()

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