Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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( SUMMARIZ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous so you want average # of customers per year. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    parry2k yes, that is right

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      7 years ago

      Anonymous is this what you want?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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.