topic Re: ROUNDUP not working as expected in DAX Commands and Tips

ROUNDUP not working as expected

Tob_P — Wed, 04 Sep 2024 13:15:19 GMT

Hi,

I have a two measures for "Courses", the first a simple multiplication, the second a ROUNDUP version of the previous measure, both working as expected. I want to multiply the two measures by each other (in this example, the values are 8 x 8 to achieve 64).

Here's my new measure...

m2 =

VAR Courses = ROUNDUP([Courses], 1)

VAR Metres = 'SL Metres Parameter'[SL Metres Parameter Value]

RETURN

Courses*Metres

...this returns 60. Even if I change VAR Courses to Measure 2, it returns the same value (in this case it is multiplying 7.5 * 😎

How can I fix this so that it returns 64, as it should?

Re: ROUNDUP not working as expected

some_bih — Wed, 04 Sep 2024 13:34:18 GMT

Hi Tob_P red coloured part below is measure definition, not column definition as in VAR Metres. It should be probably as in m2_test, assuming the data for both VAR's coming from single tableb and Courses is column

m2 =

VAR Courses = ROUNDUP([Courses], 1)

VAR Metres = 'SL Metres Parameter'[SL Metres Parameter Value]

RETURN

Courses*Metres

m2_test=

VAR Courses = ROUNDUP('SL Metres Parameter'[Courses], 1)

VAR Metres = 'SL Metres Parameter'[SL Metres Parameter Value]

RETURN

Courses*Metres

Re: ROUNDUP not working as expected

dharmendars007 — Wed, 04 Sep 2024 13:40:33 GMT

Hello Tob_P ,

Please use the below DAX in the Variable Courses..

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

Thank You

Dharmendar S

Re: ROUNDUP not working as expected

Tob_P — Wed, 04 Sep 2024 13:48:45 GMT

some_bih

Thank you, gave that a go but no luck. Courses isn't actually a column within a table - I'm using Parameters so it's the Parameter Value divide by another measure, so I wonder if that's the issue that it won't round up accurately?

Re: ROUNDUP not working as expected

some_bih — Wed, 04 Sep 2024 17:04:26 GMT

Hi Tob_P please share model and relationships for more possible solutions. If both VAR are columms, it should be simple.

Re: ROUNDUP not working as expected

Tob_P — Thu, 05 Sep 2024 08:23:02 GMT

Hi some_bih

Link to .pbix...

https://drive.google.com/file/d/1PUQzM_7DMh_y5Yp8qbi-PMFWWkekL1RB/view?usp=sharing

The bottom two sections are what I'm referring to.

Thanks

Re: ROUNDUP not working as expected

some_bih — Thu, 05 Sep 2024 13:38:22 GMT

Hi Tob_P

It seems that your issue is related to function ROUNDUP.

As in your example value for one of your VAR is 7,50 (Metres) so you probably expect 8,00? Which should lead later to 64 (8*8=64).

Still, function ROUNDUP in DAX function with specific behaviour for your case 7,50. Check link with example

To get 64 in your case just adjust your part with ROUND (no UP at and) and 0 for end.

VAR Courses = ROUND('SL Height Parameter'[Courses], 0)

Re: ROUNDUP not working as expected

Tob_P — Thu, 05 Sep 2024 14:02:45 GMT

Hi some_bih - thank you and obviously works a treat - so straightforward really!

Thanks again.