Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Syndicate_Admin
Administrator
Administrator

Customer Coverage

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 )

4 REPLIES 4
lbendlin
Super User
Super User

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

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 CustomerClient DescriptionCod ItemArticle DescriptionSale DateONEBoxes
92844Johana Maria Padilla Estrada5965Canned corn 410gr03/01/2020241
10746Maria Pilar5966Canned corn 410gr04/01/202024060
22560Kellyn Romero Market5967Canned corn 410gr06/01/2020482
97605Haydee Maria Sunsin Scott5968Canned corn 410gr06/01/2020120.5
24863Mayra Maria Bravo Romero5969Canned corn 410gr08/01/2020241
91841Nereya Balladares Sandobal5973Canned corn 410gr11/01/2020241
35758Adelia Clemencia Ramires Mejia5974Canned corn 410gr11/01/202020.12
22560Kellyn Romero Market5975Canned corn 410gr30/1/2020-48-2
24863Mayra Maria Bravo Romero5976Canned corn 410gr30/1/2020-24-1

see attached.

God bless you, thanks a lot.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors