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 

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

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

     

    Thanks again.