Forum Discussion

Vitalijus's avatar
Vitalijus
Frequent Visitor
6 years ago

Conditional Formatting One Value Different Icons

Hi, Created a simple Conditional Formatting rule, but sometimes value 1 shows Yellow which is incorrect, according to the rule value 1 shuld be Green always, where could be the problem? I posted lik...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Agreed with Pragati11, check the data types.  Is there DAX doing the calculation?  If not, try coding the DAX one of three ways:

DivideColumn = Numbers[Actual]/Numbers[Forecast]
DivideMeasure = SUM(Numbers[Actual])/SUM(Numbers[Forecast])
DivideMeasureDiv = DIVIDE(SUM(Numbers[Actual]),SUM(Numbers[Forecast]))
Tested all three and the behavior was the same (June 2020 release).