Hi, Whilst working on an analysis services report I came across an issue with the conditional formatting functionality. After creating a new measure which produces a variance column I wanted to h...
I had a similar "reversing" issue when trying to apply red X icons to "0" values and green tick icons to "1" values. It was reversing everything, making 0 green and 1 red. It turned out I had to change it from "Summarization by Count" to "Summarization by Sum" in the Advanced Controls menu, before it then it correctly followed my instructions. (Slightly different than your set-up, but posting in case it helps.)
Regards,
Sarah