Forum Discussion

szucsandras37's avatar
szucsandras37
Frequent Visitor
3 years ago
Solved

SUMX and ROUNDUP

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...
DAX
not correct total
Roundup
sumx
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi szucsandras37 

    please try

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

johnt75's avatar
johnt75
Super User
3 years ago

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's avatar
    szucsandras37
    Frequent Visitor
    3 years ago

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