Forum Discussion

Atlsql's avatar
Atlsql
Frequent Visitor
2 years ago
Solved

Conditional Formatting / Data Type.

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
 
General Comment
  • lbendlin's avatar
    lbendlin
    2 years ago

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

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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