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
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Suzie_Suze_Sue 

not sure if i fully get your, please create a calculated table with this:

SumTable = 
VAR _table = 
ADDCOLUMNS(
    VALUES( TableName[Year] ),
    "FTE",
    CALCULATE(SUM(TableName[FTE]))
)
RETURN
ADDCOLUMNS(
     _table,
    "FTE Rounded",
    MROUND([FTE], 5)
)

 

i tried and it worked like this:

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

    Thanks this works in a table, but doesn't work when adding in a slicer.

    Say for example I needed a matrix in Gender by year with a larger dataset, and then want to filer by qualification

    Filter = Dip

                    16/17             17/18         18/19        19/20          20/21

    Male         222 (220)       256(255)    212(210)    248(250)    227(225)

    Female      229 (230)       246(245)    232(230)    248(250)    207(205)

    Would I need to add multiple columns in? In brackets is the rounded numbers, don't need to to displayed this way, but this is what should be pulling through rather than the whole number.

    Thank you very much

    • FreemanZ's avatar
      FreemanZ
      Icon for Super User rankSuper User
      3 years ago

      hi Suzie_Suze_Sue1 

      you would need a measure like this:

      measure = 
VAR _sum = SUM(TableName[FTE])
RETURN
MROUND(_sum, 5)

       

      with the sample data you provided in the original post and changing 5 to 2, it worked like this:

       

      p.s. please consider @someone, if you seek further suggestions. 

       

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

        Perfect!! Thank you