Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
szucsandras37
Frequent Visitor

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?
1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @szucsandras37 

please try

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

View solution in original post

3 REPLIES 3
johnt75
Super User
Super User

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.

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

tamerj1
Super User
Super User

Hi @szucsandras37 

please try

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors