Solved: Dependent Drop Down List 2 level - Page 2

Leo-Enoch · 06-26-2020 09:51 AM

Hi everyone,

I was trying to do a 2 level dependent drop down list, but could not get it working.

Example:

I have list of Bank Name Drop down then then list of Account No and Then list of FX.

In first list to choose, I place in Bank Name Column this validif = Bank[Bank Name]
Then in Account No Column validif = Bank[Account No]

and now from these account no, I need to choose drop down list of all the currencies

so on Currencies Column I place validif = Bank[FX].

I manage to get the dependent drop down to Account No, but not to the Currency.

I am not sure where I make the mistake is.

Thanks

LeventK

Your shall try with

SELECT(
    Bank Pogen[FX],
    AND(
        [_THISROW].[Bank] = [Bank],
        [_THISROW].[Account No] = [Account No]
    )
)