5 Replies Latest reply: Jun 29, 2017 10:06 AM by Eduardo DImperio RSS

    Using Set Analisys to limit rows

    Eduardo DImperio

      Hi !

       

       

      I need to show only rows where the AVG  are <-90 and The distance of Distancia_Torre_Ativa> Distancia_Torre_Inativa

      So, if i use 'IF' on the measure, i get AVG(SIGNAL) or '-' and i can't eliminate '-' because it's a measure and QS doesn't give the option 'not show null' to measures and i can't either use in the dimension because is an agregation.

       

       

      How can i do to show only the rows that satisfy this condition?

       

      Avg(SIGNAL)<-90 AND Min(Distancia_Torre_Ativa)>Min(Distancia_Torre_Inativa)


      Thank you