Forum Discussion

Tob_P's avatar
Tob_P
Helper V
1 year 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 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?
"Need Help"
  • some_bih's avatar
    some_bih
    1 year 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)

7 Replies

  • some_bih's avatar
    some_bih
    Community Champion
    1 year 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
      Helper V
      1 year ago

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

       

      Thanks again.

  • some_bih's avatar
    some_bih
    Community Champion
    1 year 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
      Helper V
      1 year 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?

      • some_bih's avatar
        some_bih
        Community Champion
        1 year ago

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

  • dharmendars007's avatar
    dharmendars007
    Memorable Member
    1 year ago

    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