Ignore selected field in my if-expression

[Bobi]

Hi. I want to ignore so that when I make a selection in the field "Job Family", this should be ignored in the following expression. To simplify; It is basically for this part of the expression I want to ignore the selections for the field "Job Family": 

(if ( Avg([TTC_1])-avg([MarketData.TTC]) >0,'Higher than market','Lower than market' ) ))

My expression (entire expression):

if(sum([MarketData.Organizations])<10 and (sum([1])>0 or sum([TTC_1])>0),'Too little data',
if([Salary Measure]='TTC',

if(getselectedcount([IPE])>=1 and getselectedcount([Country])>=1 and getselectedcount(Function)>=1,

(if ( Avg([TTC_1])-avg([MarketData.TTC]) >0,'Higher than market','Lower than market' ) ))

,
if(getselectedcount([IPE])>=1 and getselectedcount([Country])>=1 and getselectedcount(Function)>=1,

(if ( Avg([1])-avg([MarketData.ABS]) >0,'Higher than market','Lower than market' ) )) ) )

[Kushal_Chawda]

In which ever aggregation part you want to exclude the selection of field you can simply use the modifier using set as below

 Avg({<[Job Family]>}[TTC_1])

you can use this modifier in all the aggregation wherever you want to exclude selection

[Bobi]

Hi. I tried that solution before. However that gives me a lot of null-values since the table gets populated with all job families.

I have selected one function (lets say finance). Then due to these changes I automatically get 4 values in the table for job family: accounting, controlling and so on. 

This is one of the columns that gets populated with all job familys now when I have med one selection. Before this change it was just populated with the job families selected. 

=if(getselectedcount([Function])>=1 and getselectedcount([Job Family])>=1,[Job Family])