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,

 

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.