Data duplicate issue

I have created a VC for monthly sum with the formula

SUM(
SELECT(
Daily trip[Amount],
AND(
([Customer] = [_THISROW].[Customer]),
([Month] = [_THISROW].[Month])
)
)
)

But the issue sum is correct but while creating a UX tab with customer “name and sum”, it’s showing duplicate in the customer list.

For the below, I want all in a single line

Try putting UNIQUE() around it.

1 Like