IN( [_THIS], SELECT(Regions[Country], [_THISR...

[Test_Birimi]

IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region]))

If I use this formula as follows, the filter is not applied, what could be the problem?

IFS( [City] = “Istanbul”, IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region])) )

When I use it as a valid if value, there is no error but no filtering is available.

@praveen

[tony1]

@Test_Birimi Your IFS needs to return a default case, probably:

IFS( …same as above, FALSE )

[Test_Birimi]

Unfortunately, it did not happen IFS function is used incorrectly:Inputs to IFS() must be one or more condition-value pairs

@tony

[tony1]

@Test_Birimi You could just use the IF function

IF([City] = “Istanbul”, IN(whatever), FALSE)

You need to consider what to return when the city is not istanbul.

[Test_Birimi]

IFS( [City] = “Istanbul”, IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region])), false, IN( [_THIS], Regions[Country]) )

this did not fail but did not

[Test_Birimi]

IF( [City] = “Istanbul”, IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region])),IN( [_THIS], Regions[Country]) )

[Test_Birimi]

unfortunately this did not happen, formula is running but not dropdown filtering

[Aleksi_Alkio]

Try…

IF([City] = “Istanbul”, SELECT(Regions[Country],[_THISROW].[Lead Region]=[Region]), Regions[Country])

[Test_Birimi]

@Aleksi_Alkio You are as magnificent as ever, thank you very much.

[Aleksi_Alkio]

You’re welcome