Forum Discussion

oester's avatar
oester
Icon for Advocate II rankAdvocate II
8 years ago

DAX performance FILTER & RELATED issue

Hi there,   I was facing severe performance issues on this DAX formula:   CALCULATE(COUNTROWS('Measure Touchpoint');FILTER('Touchpoint Attribute';'Touchpoint Attribute'[IsIn30PC]=1))   It never...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Since you are comparing a column to a fixed value, you do not need the FILTER function.  Try this

 

=CALCULATE(COUNTROWS('Measure Touchpoint');'Touchpoint Attribute'[IsIn30PC]=1)
 

Does this work?

oester's avatar
oester
Icon for Advocate II rankAdvocate II
8 years ago

Thanks for your reply.

 

Isn't this just a syntactical shortcut of the FILTER version? Anyway, my questions is about the difference between using RELATED or not in a FILTER statement

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi,

     

    As long as there is a relationship between Measure Touchpoint table to the Touchpoint attribute table, my fomrula should work fine.  Have you tried it?

    • oester's avatar
      oester
      Icon for Advocate II rankAdvocate II
      8 years ago

      Yes, it works. But still, I'm wondering about the bad performance when using RELATED in my given example.