Hello all need help please

[mohamed_sharaf]

i need to prevent duplicate the customer name in this row
I use
not(in([_this], select( Report[Customer Name], not(in([Report_ID], list([_thisrow].[Report_ID]))))))
and work is good but I need add other condtion this also only when column [Status]=Open
how to make this
I mean customer name not dublecated only when the Status colum also =open

[WillowMobileSys]

First, this part of your expression:
not(in([Report_ID], list([_thisrow].[Report_ID])))

is equivalent to:
[Report_ID] <> [_thisrow].[Report_ID]

---

Second, I am not clear which table the Status column is located - the “current” or the Report table.

If Status is located in the “current” table then I think you might be looking for this expression?

AND(
         [Status]=Open,
         not(in([_this], select( Report[Customer Name], [Report_ID] <> [_thisrow].[Report_ID])))
)

If Status is in the Report table then maybe this is what you need?

not(in([_this], select( Report[Customer Name], AND([Status]=Open,
                                                   [Report_ID] <> [_thisrow].[Report_ID]))))

---

I hope this helps!