3 Replies Latest reply: Sep 2, 2016 3:13 AM by Gysbert Wassenaar RSS

    Background color expression in pivot table

    Nishanthi Rajendran

      if((Count( {<[Module 1]={'Completed'}>}[user name]))


      (Count( {<[Module 1]={'Completed'}>}[user name])


      Count( {<[Module 1]={'Not Completed'}>}[user name]))


      The above expression works individually but i if i give numerator the else part is not at all executed for background color expression?

      Is there any solution ?