Row filter expression for slice

[Dave2]

Hi

I’m trying to create a row filter expression for a slice with the following criteria:

AND([Procedure]=“Task Analysis”, [Status]=“Current”, [Step #]= ??? ))

It’s the third criterion that I’m struggling with, because I need the list of records with the lowest number (that’s also “current” and a “task analysis” obviously), and it can be any number from 1-15. I’ve played around with MINROW and LIST() but nothing has worked so far. Thanks!

[Steve · Accepted solution]

Try:

AND(
  ([Procedure] = “Task Analysis”),
  ([Status] = “Current”),
  (
    [Step #]
    = MIN(
      SELECT(
        table[Step #],
        AND(
          ([Procedure] = [_THISROW].[Procedure]),
          ([Status] = [_TTHISROW].[Status])
        )
      )
    )
  )
)

replacing table with the name of the table.

[Dave2]

Steve! You’re my hero, man. It worked. Thanks!