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!