Forum Discussion
Slow DAX measure
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])
6 Replies
- parry2k
Super User
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
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.
