Forum Discussion

Suzie_Suze_Sue's avatar
Suzie_Suze_Sue
New Member
3 years ago

MROUND - Rounding to the nearest 5

Good afternoon, Having an issue with MROUND. I have a table with college courses, and would like to look at the FTE for each institution and course, how ever it doesn't seem to like "the value for ...
MROUND
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Suzie_Suze_Sue , this you need to create a new column

 

FTE Rounded = MROUND([FTE]),5)

 

 

The measure will be like

 

FTE Rounded =Sumx(Table,  MROUND([FTE]),5) )

  • Suzie_Suze_Sue1's avatar
    Suzie_Suze_Sue1
    Icon for Helper I rankHelper I
    3 years ago

    Thanks

    I have tried this and get the error

    The syntaxt for ') is incorrect. 9DAX(Sumx(Table, MROUND([FTE]),5) ))).

    • johnyip's avatar
      johnyip
      Icon for Solution Sage rankSolution Sage
      3 years ago

      Try this:

      FTE Rounded =Sumx(Table,  MROUND([FTE],5) )