Static Charts

[RichardLee]

I have several charts which use

If([Date.Size]='4mm',Avg([Actual Cost £]))

or similar to get the data. How can I make the chart visual and data stay regardless of the filters selected.   

[Angela_Zhou]

Have you tried? with correction 

     Avg({1} If( [Date.Size]='4mm', [Actual Cost £]) )

Here, the set identifier {1} = ignore any selection and count all data, dimension still affect your AVG result

[RichardLee]

Thanks for the reply. I have tried this and the chart still filters.

[edwin]

is Date.Size also used as a filter?  if so use set analysis:

Avg({1<Date.Szie={'4mm'>}[Actual cost])

[RichardLee]

Not sure that this would work.

[edwin]

no worries, eventually someone will be able to help.  posting sample data as well will do wonders

[vinieme12]

As soon as you use and if() block, this will respond to all selections , do the filtering in Set Analysis

as below

Avg({1<[Date.Size]={'4mm'}>} [Actual Cost £])

[Angela_Zhou]

@vinieme12 

You are right on if block outside the AVG() function.  It should work we put if block inside AVG() as my correction above like, Avg({1} If( [Date.Size]='4mm', [Actual Cost £]) )

[vinieme12]

This will have a performance hit, best to use set analysis

[Angela_Zhou]

@vinieme12 

I am agree with you about performance better by using Set Analysis.  Just try to show new user how AVG + if will still work if there is no performance concern.