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...
  • tamerj1's avatar
    3 years ago

    Hi szucsandras37 

    please try

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