Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX Measure Optimization and Correction - Avg. SKUs per Invoice - Filter/RelatedTable/DistinctCount

Hello everyone! First of all thank you very much for taking the time to read this question, is is about both a DAX measure optimization and correction.     1. I have a data model that consist of t...
Need Help
gmsamborn's avatar
gmsamborn
Icon for Super User rankSuper User
3 years ago

Hi Anonymous 

In your slow measure where your are defining the vTable_2 variable, would it make any difference to remove 'dimCustomer' from 'dimCustomer'[customer_code] ?

 

I'm not sure if would make a difference but maybe it's worth a try.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks for the idea! Unfortunately, I tried both removing dimCustomer from dimCustomer[customer_code] in vTable_2 and factSales from factSales[invoice_type] in vTable_0 but performance is basically the same, for a filter applied on a lot of rows this is the result.
with table name = 37588 ms
vs

without table name 36548 ms.

  • gmsamborn's avatar
    gmsamborn
    Icon for Super User rankSuper User
    3 years ago

    Anonymous 

    If I think of anything else, I'll let you know.  I'm going to watch the thread because I'd like to find out what other ideas might come up.

    Good Luck

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you!! I will still work on it on my side and post if anything changes.