Limit Ammount of AND expression

[williamsanj13]

Hi There,

i was curious about ammount limit condition on AND expression
example

I was looking value on Visibility Dropdown with these condition
[Dropdown Category]="Transaction", [Dropdown Type]="Pembelian", [Text Dropdown 1]="Created"

Ex 1, (using all the condition)
SELECT(Dropdown[Dropdown Visibility],AND([Dropdown Category]="Transaction", [Dropdown Type]="Pembelian", [Text Dropdown 1]="Created"))
and return blank value

Ex 2, (Using only 2 condition)
SELECT(Dropdown[Dropdown Visibility],AND([Dropdown Type]="Pembelian", [Text Dropdown 1]="Created"))
it works, and return value on specific Dropdown visibility that i looking for

can you explain to me about it? thanks 

[Koichi_Tsuji · Accepted solution]

Your expression syntax is well organized. Better to check if your data table does have rows, matching the condition of [Dropdown Category]="Transaction"

[williamsanj13]

i have check the tables rows, and its still same, idk why 🤦‍♂️, but thanks 😄