Conditional Formatting / Data Type.

[Atlsql]

We have a dashboard with conditional formatting on a value.  

< 4.70 the cell turns yellow. 

>= 4.70 the cell turns light green. 

The expression that is evaluated is SumOfScore ( Decimal ) / CountOfScores ( Int ). 

The oddity is that at the value of 4.7 ( 84.6 / 18 ) the cell is being colored yellow.

I came up with a work around - but I'd love to understand why if someone knows.  I suspect that it has something to do with the data types, but with a value that Excel says is 4.7000000000 I'm at a loss as to why PowerBI is evaluating that as something less then 4.7.

Turns Cell Yellow

msNameOfMeasure =

var TotalScores = Calculate(SUM(FactTable[TotalScore]))

var CountofScores = Calculate(SUM(FactTable[CountOfSCores]))

return TotalScores / CountofScores

Turns Cell Green ( As designed )

msNameOfMeasure =

var TotalScores = Convert(Calculate(SUM(FactTable[TotalScore])), CURRENCY)

var CountofScores = Convert(Calculate(SUM(FactTable[CountOfSCores])), DOUBLE)

return TotalScores / CountofScores

[lbendlin · Accepted solution]

Decimal numbers are always approximations. Use ROUND etc to force the result of a division to snap to an integer.