The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 )
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 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 |
God bless you, thanks a lot.