Forum Discussion

heidibb's avatar
heidibb
Icon for Helper IV rankHelper IV
2 years ago

Help using the CALCULATE with FILTER ALL

Hello, I am struggling with the performance of this calculation --  it is causing my visuals to spin and is using up a lot of resources.  Success LY UG = CALCULATE ( [% Final Grade Success]...
Need Help
sevenhills's avatar
sevenhills
Icon for Super User rankSuper User
2 years ago

Curious what would you get if you do this:

 

Success LY UG = CALCULATE (
       [% Final Grade Success],
       filter(all(sp_TermData),
               sp_TermData[TermAxis] = max(sp_TermData[TermAxis])-6)
               && sp_TermData[TermAcademicLevelCode] = "UG"
       )
 )
 
if this work,s then the issue is you are trying to do filter with "all" twice and it has to do for each ... 
 
 
Optional: If the above does not work, You can try to see the DAX generated (sometimes helps), using Performance Analyzer and click the refresh button. 
             View Tab > Performance Analzer
             Home Tab > Refresh

🙂