Rounding question

Okay i missed that the round was within the iterator of the sumx function. Can you move the round function out of the expression like so:

test =
ROUND (
    SUMX (
        Table,
        VAR r1 = IF ( Table[Column] = "Tax", Table[Column2], 0 ) RETURN rt1
    ),
    1
)

Or do you actually need to round the number before summing them together?

More info on Variables in DAX: https://www.sqlbi.com/articles/variables-in-dax/ 

If this post helped, please mark my post as a solution

Regards,

Thomas Hanson

Individual Contributor

As ROUND is within SUMX it is evaluted for each row in HoldingsReportData before all eveluated rows summed up together in the total row. If you want the total to rounded, wrap it around the SUMX expression instead.