Solved: Dependent dropdown create a List with Ref from two... - Page 2

danieledr · 12-13-2022 09:01 AM

Hi all,
I have 3 tables

DEPENDENCED DROPDOWN

UTENTE
ALIMENTI
SESSIONE

In SESSIONE, UTENTE will enter the details of his breakfast, lunch, etc., based on his diet. In fact, the ALIMENTI table is a table that provides different foods for three types of diets: VEGAN, VEGETARIAN, OMNIVORED.
So every time a user claims to be VEGAN (UTENTE DASDASDASDASDAS and CIBO VEGANO text label), VEGETARIAN or OMNIVORED, the ALIMENTI table (CIBO VEGANO) shown in the dropdown should filter the type of food!
But that doesn't work!

I tried many solutions:

FILTER("ALIMENTI",IN([CAT],UTENTE[CATEGORIA]))
SELECT(ALIMENTI[NOME], CONTAINS([CATEGORIA], [CAT]))
FILTER("ALIMENTI",IN([CAT],ALIMENTI[CATEGORIA]))
FILTER("ALIMENTI",IN([CAT],UTENTE[CATEG]))
FILTER("ALIMENTI",IN([_THISROW].[CAT],ALIMENTI[CATEGORIA]))
SELECT(ALIMENTI[NAME], ALIMENTI[CATEGORIA] = UTENTE[CATEG])
SELECT(ALIMENTI[NAME], INTERSECT ([_THISROW].[CAT], [CATEGORIA])=[CAT])

Please help me!

WillowMobileSys

I guess my confusion is understanding what "Utente" was. It's the User?

@danieledr wrote:

@WillowMobileSys wrote:

You probably need to change the "[Utente]" column names to those that are actually in your table ALEMENTI and the column in the table used by current row

Sorry, but I'm not understand.

Because of lack of understanding, my usage of "Utente" probably didn't match with your columns. You needed to update the proper columns.

But now that I see your ALEMENTI table and understand 'Utente" is User, this is the expression I think you need:

FILTER("ALIMENTI",  [Categoria] = [_THISROW].[Utente].[Categoria])

Again I am assuming the column name in your "Utente" table. You will need to adjust [_THISROW].[Utente].[Categoria], by replacing "Categoria" with correct column where you are recording the diet type for the user. And again I am assuming that those values in the Utente table for the user will be VEGAN, VEGETARIAN or OMNIVORED.

View solution in original post

Dependent dropdown create a List with Ref from two tables