Orderby Filter Enums from Columns based on selected enums in enumlist

[Michael_at_Graz]

Hello Everybody.

I have the following Problem:

I have a inventory app, where i can select articelgroups ( enumlist ) and based on the group, i can select the article i want to count.

Ive Created a column enumlist, where i can select the articelgroups from the table articlegroups and a column articelnumbers, where every articlenumber from this articelgroup, should be shown, as i have the group selected.

my problem is, if i start the first inventory, everything works fine. after i start the second, the articelnumbers does not longer match to my selected groups.

I have tryed following expression in the suggested_values for the articelnumbers:

SELECT(
Artikel[Artikelnummer],
[Artikelgruppe] = IN([Artikelgruppe],[_THISROW].[Artikelgruppen])
)

Orderby(
Filter(
"Artikel",
[Artikelgruppe] = IN([Artikelgruppe],[_THISROW].[Artikelgruppen])
),
[Bezeichnung]
)

[Artikelguppe] = the articlegroup of the articel

[Artikelgruppen] = the choosen groups in enumlist in the inventory app

[Bezeichnung] = Name of the Article

"Artikel" = Table with all Articles

[Artikelnummer] = ID from the Article

Please can anyone tell me, whats wrong or do i think wrong with the in statement?

Many thanks in advance.

[Denny774]

Servus,

Artikelgruppen EnumList Valid_If Expression   = FILTER("Artikelgruppen", TRUE)
Artikel Ref oder EnumList  Valid_If Expression = FILTER("Artikel", IN([Artikelgruppe], [_THISROW].[Artikelgruppen]))

Cheers