8 Replies Latest reply: Oct 15, 2015 3:27 PM by Srinivas Chitrapu RSS

    Set Analysis, Avoiding all selections except one

      Hi everyone,


      I need to calculate the mesoure below:


      =count( DISTINCT{<Estado={'Desactivado'}>} [ID Recurso] )/count( DISTINCT [ID Recurso] )


      My problem is that I need to ignore ALL the selections except one(for example, Field_1).  I have many fields that can be selected and I cant set each one.


      Is there anything i can do to avoid all the selections but the Field_1?


      Appreciate your help!