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.
Hi,
For each row i have a column dat I want to roundup
ROUNDUP[QTY];0)
ID | Vendor | Qty | Roundup 1 | A | 0,3 | 1 2 | B | 1,6 | 2 3 | A | 1,2 | 2
Now i want the the sum of the roundup column for each Vendor. At this moment the the table calculates first the sum of the QTY and after that its ROUNDUP
For Vendor A => 0,3 + 1,2 = 1,5 (roundup 2,0)
For Vendor B => 1,6 = (roundup 2,0)
Total roundup = 4,0
The total isn't correct at this moment, the answer must be "8"
Solved! Go to Solution.
Hey,
you have to adjust your Measure somewhat, but without knowing your formual it's also a little guesswork, if you want to round first, you have to use a tableiterator that calculates an expression on the row level and finally creates the sum
CALCULATE(
SUMX('yourtable'[customer], ROUNDUP('yourtable'[qty]'))
)
Hope this helps
Hey,
you have to adjust your Measure somewhat, but without knowing your formual it's also a little guesswork, if you want to round first, you have to use a tableiterator that calculates an expression on the row level and finally creates the sum
CALCULATE(
SUMX('yourtable'[customer], ROUNDUP('yourtable'[qty]'))
)
Hope this helps
Thanks, this is the solution
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |