Sum of 12M sales for all client + define status of client

[Anonymous]

Hello everybody,

I currently got to problem that I cant solve. The problem is:

I want to show the client stucture count of (Top/Medium/Low/Inactive) based on the sales performance of last 12 month, in column chart for each month. So what I did was to create a new table with all the distinc clients and the distinc months. So for each client I have all the months that I can sum the sales (dolars) and define the status. But it seams I have a low memory in my pc as the based dataset is really big so the SUM function with 2 filters month year and client never finishes.

My function that never finishes is a sumx(if(and …….)

So I need to have a table with client /month year / sum last 12m / sum specific month/ status in new table to be able to display the desire result.

I am able to creat this table inside the Power Bi with mesures but I cant show the results as its all dynamic.

Any idea how to create this new table/metric that will give me the count of specific client in a specific month?

Thanks.

[Anonymous]

Hi @Anonymous ,

"I am able to creat this table inside the Power Bi with mesures but I cant show the results as its all dynamic."  -- You want a table instead a visual?

https://docs.microsoft.com/en-us/dax/summarize-function-dax 

SUMMARIZE() function might do this job but without any data we can't test.

Best Regards,

Jay

[PaulDBrown]

Please share sample data (not an image) or a PBIX file and a depiction of the expected  result