not correct total
1 TopicSUMX 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 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?Solved1.4KViews0likes3Comments
