SUMX and ROUNDUP

[szucsandras37]

Hey all,

I have a company live BI dataset I'm connected to, so using measures is the only option to calculate what I want.

Simple dataset example:

order	amount	rounded value
1	1,2	2
2	0,9	1
3	4,2	5
TOTAL	6,3	should be 8 (total of the column) but insted it rounds the 6,3 -> 7

The formula I use, which helped others in the forum

ordered = CALCULATE( SUMX( 'Sales Orders Measures', roundup([Amount],0) ) )

Has anyone else met this before, and has some suggestion?

[johnt75]

I've used the same measure against that data and it gives 8 as the total.

Is the 'Sales Orders Measures' table the table which includes the order number? Is [Amount] a column or a measure ?

I've used 

ordered = CALCULATE( SUMX('Table2', ROUNDUP( 'Table2'[amount],0)))

where Table2 contains the data and it is performing the ROUNDUP against a column, not a measure.

[szucsandras37]

Nope. 'Sales Orders Measures' has the amount, and Sales has the order number.

[tamerj1 · Accepted solution]

Hi @szucsandras37 

please try

ordered = SUMX( VALUES('Sales'[Order]), roundup([Amount],0) )