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

    Set Analysis, Avoiding all selections except one

    Clara Garcia

      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!

       

      Thanks,