Forum Discussion
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.
Hello,
I wouldn't expect this behavior from the ROUND function either. Can you please do a couple checks to make sure 8 wasn't entered in:
1. Under Measure tools ribbon > Formatting, make sure either Auto or 1 is shown
2. In Format Visual pane > Specific column > Values > Value decimal places shows Auto or 1
What happens if you put the measure in a card visual?
If this post helped, please mark my post as a solution
Regards,
Thomas Hanson
Individual Contributor