count if a condition is met on another field

[asammon]

Trying to build a more complex expression for a KPI. 

I want to only count the number of rows of apple in the "fruit" column if the amount is 5 or more.

So I like to see Apple count is 2 because there is 2 apple rows where the amount is 5 or higher. My expression is just not working.

Here is my expression:

Count({$<[fruit]={"Apple"}>,[Amount]={">5"}>})

It tells me there is an error in my expression: '}' expected, What does that mean. data below. Thanks.

[tresesco · Accepted solution]

Try like:

Count({$<[fruit]={'Apple'},[Amount]={">=5"}>} fruit)

Few corrections are made that are highlighted and removed one extra '>'. Also check and make necessary change if your field names are correct, i.e. - 'fruit' and 'Fruit' are different.

[asammon]

Thank you Tresesco! It worked.