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 anot...
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()))
     
     
v-diye-msft's avatar
v-diye-msft
Icon for Community Support rankCommunity 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!