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
User | Count |
---|---|
30 | |
26 | |
26 | |
21 | |
21 |