Slow DAX measure

[Anonymous]

Hi everyone!

I need to plot a measurement in a table, but it almost takes a minute to load the data. How can I solve this?

The DAX-formula is as follows:

# customers =

AVERAGEX(

SUMMARIZE(Customers;

[Year];

[Month];

"DC"; DISTINCTCOUNT(Customers[Customer_ID]));

[DC])

[parry2k]

@Anonymous can you share sample data with expected resull, read more on how to get you answer quickly

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

Hi @parry2k ,

Thanks for your reply!

The image above contains data about number of customers per year and in different areas. The following link contains data about customers have visted our organization:

https://drive.google.com/open?id=1qcE1U2H8cUWldUr0TOoaOSM6KJfXv-Ks

I hope this helps! If you need more information, let me know.

[parry2k]

@Anonymous so you want average # of customers per year. 

[Anonymous]

@parry2k yes, that is right

[parry2k]

@Anonymous is this what you want?

[Anonymous]

Hey @parry2k ,

No, I am sorry. The formula I have is working fine; the outcome of those numbers are correct. What I meant, was that I takes to long to load the table with the numbers in the report, since it has to make a couple of calculations every time you load that table.