Duplicate value

[Anchor_Appadmin]

Hi,

I have created a slice based on the below formula, But I’m getting duplicates in customers. can I get a unique customer list. I have a column [customer]

Table name : Daily Trip

AND(
[Date] >=
ANY(
SELECT(
Permission[Tally Report From],
TRUE
)
),
[Date] <=
ANY(
SELECT(
Permission[Tally Report To],
TRUE
)
)
)

the result is like this

[Steve]

Maybe this?

ISNOTBLANK(
  FILTER(
    "Permission",
    AND(
      ([_THISROW].[Date] >= [Tally Report From]),
      ([_THISROW].[Date] <= [Tally Report To]),
      ISBLANK(
        FILTER(
          "Permission",
          AND(
            ([_ROWNUMBER] < [_THISROW-1].[_ROWNUMBER]),
            ([Customer] = [_THISROW-1].[Customer]),
            ([_THISROW].[Date] >= [Tally Report From]),
            ([_THISROW].[Date] <= [Tally Report To])
          )
        )
      )
    )
  )
)