Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |