Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
please try
ordered = SUMX( VALUES('Sales'[Order]), roundup([Amount],0) )
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.
User | Count |
---|---|
47 | |
26 | |
21 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |