Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Performance issues with SUMX

 
Hi, everyone,

 

I'm working on a dax measure performance, this measure contains as function SUMX (As SUMX is an iterator function, it is degrading the performance) and I would like to use another alternative to fix the performance issue.

 

the measure that I'm working on : 

 

Measure : SUMX(FILTER(VALUES(TABLE1[Column A]),[TAG]<>BLANK()),CALCULATE(DISTINCTCOUNT(TABLE1[Column A])))
 
Thank you for your response. My best regards. 
Interesting Links
Need Help
Show and Tell
Tips and Tricks
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Try below one:

    Measure = 
    CALCULATE(DISTINCTCOUNT(Table1[Column A]),FILTER(Table1,[TAG]<>BLANK()))
     
     

2 Replies

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    Try below one:

    Measure = 
    CALCULATE(DISTINCTCOUNT(Table1[Column A]),FILTER(Table1,[TAG]<>BLANK()))
     
     
  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Hi Anonymous 

     

    Could you please let me know if my above post helps? if not, could you please share more details about your requirement. thanks!