Add Number of Sales to Customer Summary Table

[ONBjoaoribeiro]

Good afternoon,

I am trying to count the number of times a Customer has been serviced during a specific year, but somehow I cannot find the solution. I really hope you can help me out.

This is the info I have in Power BI Desktop Tables

Table One: Contains all the business data (Columns are: Customer Name, Year Service Provided, Amount Billed)

Table Two: Contains the list of alll customers and its type  (Columns are: Customer Name, Customer Type)

I want to add to Table Two a column that counts the times the Customer has been serviced during 2021. (This data is available in table one).

I know this must be easy to accomplish and I looked everywhere for an answer, but I just can't find it. 

Thank you very much in advance,

Joao

[v-jayw-msft · Accepted solution]

Hi @ONBjoaoribeiro ,

Check the formula.

Column = CALCULATE(COUNT('Table'[Customer]),FILTER('Table','Table'[year]=2020&&'Table'[Customer]='Table (2)'[Customer]))

Best Regards,

Jay

[ONBjoaoribeiro]

Thanks a lot Jay.

This worked perfectly. 

[ONBjoaoribeiro]

Hello @Krutigawale33 ,

The column count of customer name, you have  on your example, is exactly what I am trying to achieve. I need it as a calculated column on my table. See examples below:

I need the column 2020 Rango Embarques to be automatically updated, by looking up the value in column Customer+Country on the table Actual Shipments. The column should count how many rows the lookedup value appears if Ano (Year) = 2020

[Krutigawale33]

Hello @ONBjoaoribeiro ,

I have tried to create what you want by adding some dummy data.

let me know if this is what you want. if not then could you able to provide some data to analyze the problem