roundup

[Anonymous]

Hi,

For each row i have a column dat I want to roundup

ROUNDUP[QTY];0)

ID | Vendor | Qty | Roundup
1   | A     | 0,3  | 1
2   | B     | 1,6  | 2
3   | A     | 1,2  | 2
 

Now i want the the sum of the roundup column for each Vendor. At this moment the the table calculates first the sum of the QTY and after that its ROUNDUP

For Vendor A => 0,3 + 1,2 = 1,5 (roundup 2,0)

For Vendor B => 1,6 = (roundup 2,0)

Total roundup = 4,0

The total isn't correct at this moment, the answer must be "8"

[TomMartens · Accepted solution]

Hey,

you have to adjust your Measure somewhat, but without knowing your formual it's also a little guesswork, if you want to round first, you have to use a tableiterator that calculates an expression on the row level and finally creates the sum

CALCULATE(

  SUMX('yourtable'[customer], ROUNDUP('yourtable'[qty]'))
)

Hope this helps

[Anonymous]

Thanks, this is the solution