set analysis using Aggr but ignoring user selection

[guster999]

The code below gives me the required points on a line chart, but is still impacted by users selecting 1 month from Mth-Yr for example, and then the chart will only show that point.  How do I change it to ignore user selections for all the condition fields below?  thanks

Avg(Aggr(Max({$<[Journey_part]={"Overall Response"},[Colour]={'Red','Purple'},WrpCouncil={'Masterton'},[Mth-Yr]={'>=$(=v13MthsAgo)'} >}Duration),Ref_Number))

[MayilVahanan · Accepted solution]

Hi @guster999 

Try like below

Avg({1}Aggr(Max({1<[Journey_part]={"Overall Response"},[Colour]={'Red','Purple'},WrpCouncil={'Masterton'},[Mth-Yr]={'>=$(=v13MthsAgo)'} >}Duration),Ref_Number))

If v13MthsAgo variable is dynamic, you need to set {1} for this variable also.

So, based on above , we can ignore the user selection

{1} <-- ignore all the selections

[guster999]

Many thanks, that works perfectly😊