ROUNDUP not working as expected

[Tob_P]

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?

[some_bih · Accepted solution]

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)

[Tob_P]

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

Thanks again.

[dharmendars007]

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

LinkedIN 

[some_bih]

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

[Tob_P]

@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?

[some_bih]

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

[Tob_P]

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