3 Replies Latest reply: Sep 22, 2017 4:33 AM by Andy Weir RSS

    Ignore a filter in whole measure

    Jorge Sanchez

      Hi everyone,

       

      I have a bar chart with a measure made up of multiple functions:

       

      =sum(Aggr(Sum(Aggr(Avg(avance_o)*avg([peso_objetivo]),ID_objetivo))/sum(aggr(avg(peso_objetivo),ID_objetivo)) * avg([Riesgo inicial]),LT))/sum([Riesgo inicial])/100

       

      Lets say I want to ignore when "LT" filter is applied. With set analysis I can type "{$<LT>}" in the beginning of each function to ignore that filter, but,

       

      is there any way to ignore a filter globally in a measure other than typing 11 times "{$<LT>}"??

       

      I hope the answer is yes

       

      Thank you!