how to ignore 1 filter value, but keep other 3 filter?

[jiaqi]

I have an app, 1st sheet has 4 filters: year, month, type, department. after I selected filters, sheet 1 will jump to sheet 2 , and keep all the filters. and I want to have a line chart to show the score changes by year. 

but year has selected at the beginning, so the line chart cannot show the X ray with full year. the other 3 filter must keep, then  I will set avg of score. 

the question is: how can I skip the year filter, and keep others, calculate the avg with the other 3 filters.

besides, the ray may be year, may be month, depends on the type filtered. could it be possible to change automatically?

[Lisa_P]

In the avg of score measure you can tell it to ignore the year filter using set analysis.

Just place the Set analysis in front of the avg expression like this:

{<Year>}Avg(score)

[M_B]

Avg({1 < Filter1 = p(Filter1), Filter2 = p(Filter2), Filter3 = p(FieldFilter3)>} MeasureField)

{1} ignores all filters

The fields are the ones you want to keep so you can make an exception for those.

It basically reads: Ignore all filter except this, this and this.

[jiaqi]

thanks, but not working, maybe it should be {}Avg(score)

[ali_hijazi]

no the syntax is correct but the field or column year is it defined as such; I mean the column names are case sensitive

if your field is named YEAR then the syntax would be

{<YEAR>}
avg(Score)

[jelisjack4]

To achieve this, you can adjust your filtering logic so that the year filter is excluded when calculating averages.

1. Ignore the Year Filter: In your app's logic, apply the other three filters (month, type, department) while excluding the year filter when calculating the average score business 2.

2. Dynamic X-Axis: For the line chart, you can set the X-axis to dynamically adjust based on the selected filter type. This way, if the year is selected initially, the X-axis will show full-year data. If a different filter (like month) is selected, the X-axis updates accordingly.

You might need to configure these settings in your app or data visualization tool’s filter and chart options.