Solved: Re: Row Filter Formula for Slice

Amit_Jain1 · 02-12-2021 09:31 PM

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

Steve

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”
            )
          )
        )
      )
    )
  )
)

View solution in original post

perissf

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

Steve

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”
            )
          )
        )
      )
    )
  )
)

Amit_Jain1

Thanks @Steve Your Formula Worked