Count related rows with condition

I'm not sure why, but this expression seems to return the count of all related rows when what I want is to return the count of all related rows where "White Bread" is the selected option in an enumlist field called "bread".

Count(
     Select(
        [Related Food Orders][Row ID],
        In("White Bread", [Related Food Orders][Bread])
      )
)

0 3 324
3 REPLIES 3

Never mind, I figured it out:

Count(
     Select(
         [Related Food Orders][Bread],
         In("White Bread", [Bread])
     )
)

Nice to know you got it working. Sorry that I did not see your latest post before posting my response.

You could try this

Count(
     Select(
        [Related Food Orders][Child Table Key],
        [Bread]="White Bread"
      )
)

I believe the child table is "Food Orders" , please substitute key of the table "Food Orders" in the [Child Table Key] in the expression above.

Top Labels in this Space