Customer Coverage

[Syndicate_Admin]

Hello friends, I need your help, I have a database of sales to customers with different products, the fact is that I need a measure to be able to know how many customers I sold them in the month. The problem is the following:

1- Some customers place orders but reject them for different reasons so it cannot be done with Disctintcount because it would take them into account.

2- I did it with the following measure, the problem is that this solution excludes me when I want to know the imacatos customers in the year if one of these made a return in a month even if he has bought the other months will exclude it.

Coverage V2 =
VAR _Clientes_Ventas =
VALUES( BDventas[Client] )
VAR _Cliente_Devolucion =
CALCULATETABLE( VALUES( BDsales[Customer] )
, BDsales[Sale] < 0 )
VAR _Cliente_Final =
EXCEPT( _Clientes_Ventas, _Cliente_Devolucion )

RETURN
COUNTROWS(_Cliente_Final )

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Syndicate_Admin]

Hello friends, I need your help, I have a database of sales to customers with different products, the fact is that I need a measure to be able to know how many customers I sold them in the month. The problem is the following:

1- Some customers place orders but then make returns for different reasons so it can not be done with Disctintcount because at the time of returning the customer should not be counted.

2- In table there are a total of 7 customers who bought, however two of them returned the product on January 30, so my impacted customers should be only 5.

As I do it den DAX I have searched everywhere and I can not solve it., I thank you in advance.

Cod Customer	Client Description	Cod Item	Article Description	Sale Date	ONE	Boxes
92844	Johana Maria Padilla Estrada	5965	Canned corn 410gr	03/01/2020	24	1
10746	Maria Pilar	5966	Canned corn 410gr	04/01/2020	240	60
22560	Kellyn Romero Market	5967	Canned corn 410gr	06/01/2020	48	2
97605	Haydee Maria Sunsin Scott	5968	Canned corn 410gr	06/01/2020	12	0.5
24863	Mayra Maria Bravo Romero	5969	Canned corn 410gr	08/01/2020	24	1
91841	Nereya Balladares Sandobal	5973	Canned corn 410gr	11/01/2020	24	1
35758	Adelia Clemencia Ramires Mejia	5974	Canned corn 410gr	11/01/2020	2	0.12
22560	Kellyn Romero Market	5975	Canned corn 410gr	30/1/2020	-48	-2
24863	Mayra Maria Bravo Romero	5976	Canned corn 410gr	30/1/2020	-24	-1

[lbendlin]

see attached.

[Syndicate_Admin]

God bless you, thanks a lot.