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
