Forum Discussion

Tob_P's avatar
Tob_P
Icon for Helper V rankHelper V
2 years ago
Solved

ROUNDUP not working as expected

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 ...
"Need Help"
  • some_bih's avatar
    some_bih
    2 years ago

    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)
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
Tob_P
Icon for Helper V rankHelper V
2 years ago

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?