Forum Discussion

ERing's avatar
ERing
Post Partisan
2 years ago
Solved

Can't get simple conditional formatting applied correctly

I have a table where I'm trying to apply conditional formatting based on the value in the column, but the formatting doesn't seem to match the rule I've set. Somehow the background formatting is being applied to values over 30.44% and not being applied to values over 29.45%.

 

The measure I'm using is Measure_1 = DIVIDE(sum(Table[Impressions]),sum(Table[Clicks]))

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi ERing 
    Change your condition to :
    >=0.2945 NUMBER 
    <    0.3044 NUMBER

     

    it will work.

    I attached pbix with my example :

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

5 Replies