Optimize Code Help
Hi all, I have a ton of code that works, but is slow. I read that Vars and Switches can speed up things but when i try to use them it doesnt work. Here is my current measure (gives the correct an...
Forum Discussion
airwolf39 because in sumx you are using variables, the value is not getting calculated for each child part and that's why
There could be many reasons for the slow performance, how your data is modeled, and the relationship between tables.
✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
All my tables have a 1 to many reletionship. Its very clean and utilizes unique keys.
I know that you have to keep variables inside of a calculate function if you want them to work properly. I didnt realize this also applies to sumx??