I created this filter for a table lookup
FILTER("Ordini",
AND(
OR(ISBLANK([_THISROW].[Tipologia]),IN([Tipologia] , [_THISROW].[Tipologia])),
OR(ISBLANK([_THISROW].[Agenzia]),IN([Agenzia],[_THISROW].[Agenzia])),
OR(ISBLANK([_THISROW].[Tipologia_Contratto_Telefonia]),IN([Tipologia_Contratto_Telefonia],[_THISROW].[Tipologia_Contratto_Telefonia])),
OR(ISBLANK([_THISROW].[Tipologia_Contratto_Energia]),IN([Tipologia_Contratto_Energia],[_THISROW].[Tipologia_Contratto_Energia]))
)
)
On [Type] I can select in EnumLIST the values โโ"Energy" or/and "Telephony",
But the moment I go to select one of the values โโreferred to [Typology_Contract_Telephony] it excludes the results relating to the "Energy" selection, and contrary. How can I solve the problem?
LinkedIn
Twitter
