Performance issues with SUMX

[Anonymous]

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. 

[Anonymous]

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. 

[v-diye-msft]

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!

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Try below one:

Measure = 

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