Forum Discussion
Some values calculated correctly some are infinity
I have this weird thing I do not understand where a formula sometimes calculates infinity when I expect a percentage.
Any ideas how to troubleshoot this ?
are you creating a column? create a measure
FileSizeCompliancePercentage =
DIVIDE ( sum('Table'[Attributes.Size]), [MaxFileSizeNumber], 0 )
3 Replies
are you creating a column? create a measure
FileSizeCompliancePercentage =
DIVIDE ( sum('Table'[Attributes.Size]), [MaxFileSizeNumber], 0 )you are a creating a column and mixing that with a measure. Firstly its unnecessary to do that, calculated columns aren't very performant either. Basically though you are trying to divide a constant by a measure, the measure is aggregated and therefore has a different context.
if you have the values on the row anyway a measure will pick up the context and return the correct answer. not sure if that explains it well enough.