Forum Discussion

ddbaker's avatar
ddbaker
Icon for Helper I rankHelper I
4 years ago
Solved

Measure Calculations are Really Slow

Hey everyone, I have several measures that I'm using that are really slowing my report down. Wondering if any of you can provide any tips to make them more efficient.       ARR (Monthly) = VAR ...
Need Help
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    The simplest approach would be to modify your Subscriptions table and append it to your invoices table, so it looks something like this. I just added an Invoice Date to it with Date.From(DateTime.LocalNow()), and renamed the Amount column.

     

    Simpler model leads to much simpler DAX.

     

     

     

    Pat

     

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

All those nested CALCULATEs are slowing things down.  The nested IFs probably aren't good either.  Can you provide sample data and desired output, and some details about your model (tables and relationships)? Even better, share link to your pbix file (e.g., Google Drive, OneDrive).

Pat

 

ddbaker's avatar
ddbaker
Icon for Helper I rankHelper I
4 years ago

mahoneypat I updated the original post with more details.