SELECT() with multiple condition not working

[Bulubulu]

I'm trying to filter rows that have the same ref and the same numeric [Seq] value, in order to increment an initial value. Unfortunately, my second condition in line 5 does not work :

MAX(SELECT(
 Shots[Num],
  AND(
   [Storyboard] = [_THISROW].[Storyboard],
   [Seq] = [_THISROW].[Seq]
  )
)) + 10

I guess it's because the [Seq] column is a numeric value and not a reference like the [Storyboard] column is.

[WillowMobileSys]

---

@Bulubulu wrote:

I guess it's because the [Seq] column is a numeric value and not a reference like the [Storyboard] column is.

---

No, this should not be a problem.

Why is it not working?  Are you certain there are rows in the Shots table that match the selection criteria?

Why do you think it is the second condition in the AND() that is the problem? 

If you're certain it's that second condition, make sure the column type in the Shots table and [_THISROW] (whatever table that is) have the same type.  If they do then its unlikely that column is causing the problem.

What I would recommend doing is breaking down the expression.  Temporarily create a column and assign it just the SELECT().  If this temporary column doesn't return the rows you expect then investigate from there further refining the SELECT() until you discover where the issue is.

[Bulubulu · Accepted solution]

Thanks ! I found my mistake : I forgot to set the initial value of column [Seq] before. So my result was based on an empty value.

I add this initial value to [Seq] column and now it works perfectly !

MAX(SELECT(
 Shots[Seq],
 [Storyboard] = [_THISROW].[Storyboard]
))