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:

orderamountrounded value

1

1,22
20,91
34,25
TOTAL6,3should 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?
DAX
not correct total
Roundup
sumx

3 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    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.