Row Filter Formula for Slice

Hello,
I Want to Have filter Formula to Select Selected Rows for Slices

Here is Formula what i am Using in Row Filter

OR([Key Column]=“Printing”, AND(OR([Status] =“N” ,[Status]=“C”),Contains([Type],“Ptg.”),NOT(CONTAINS([Key Column],“Direct”))))

Problem Here is that it Pick Up Double Row Having Same Ciretria
I want To Have Only First Matching Row

I Want to Add Filter for Col2 to Pick up Oldest Entry

is There is any Way to Achive This

Thanks

Does it work using ORDERBY() and TOP()?

1 Like

Try the following as your slice’s row filter expression, replacing table (1x) with the name of the table:

(
  [_ROWNUMBER]
  = MIN(
    SELECT(
      table[_ROWNUMBER],
      OR(
        ([Key Column] = “Printing”),
        AND(
          OR(
            ([Status] = “N”),
            ([Status] = “C”)
          ),
          CONTAINS(
            [Type],
            “Ptg.”
          ),
          NOT(
            CONTAINS(
              [Key Column],
              “Direct”
            )
          )
        )
      )
    )
  )
)
1 Like

Thanks @Steve Your Formula Worked

1 Like