Solved: Filtering ref column by unique label? - Page 2

Binkodyl · 11-02-2020 03:13 PM

I have a column called [DataID] that references a table called “Data”. I have the label of data set to a column called [String] which has duplicate values in multiple rows, but mean different things. How can I filter the key values showing labels to be unqiue? I only want to display unique values from that column, but other rows have the same [String] value. So instead of that ref column showing five “1” values, I’d like it to only show one. How can I do this?

Steve

Try:

FILTER(
  "Data",
  ISBLANK(
    FILTER(
      "Data",
      AND(
        ([_ROWNUMBER] < [_THISROW-1].[_ROWNUMBER]),
        ([String] = [_THISROW-1].[String])
      )
    )
  )
)