Forum Discussion

GusLima121's avatar
GusLima121
Frequent Visitor
2 years ago

Reduce memory used by DAX Command

Greetings, I need help reducing the DAX Measure used memory so the calculations are shown fully.   I'm using the followin Measure to calculater Overlapping Dates Duration _Calculate Overlapping ...
AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
2 years ago

GusLima121 How big is the 'SAMPLE DATA' table? Instead of table reference use just the columns you need to reduce the total distinct values on which the calculation needs to performed.

 

instead of FILTER ( 'SAMPLE DATA' ....

 

use:

 

SUMMARIZE ( 
    'SAMPLE DATA', 
    'SAMPLE DATA'[START], 
    'SAMPLE DATA'[END] 
)

 

 

  • GusLima121's avatar
    GusLima121
    Frequent Visitor
    2 years ago

    I have a total of 5.3K rows in that table, 3.4K only in 2024, being CC 5021 with 1032 rows.

    The reason i filter the Dates is because i need it to return all orders that:

     

    1. Started and ended inside my range
    2. Started inside and ended outside
    3. Started before and ended after.

    So the filters are important to me.