topic To move the calculations in Master measures to data load editor in App Development

To move the calculations in Master measures to data load editor

Koti_Ch — Wed, 09 Feb 2022 15:13:35 GMT

Hi,

I have a bunch of Master measures that I use for my application. Now to improve the performance of the app, I'm trying to move the calculations to the backend. But the master measures have a lot of calculations in them including set analysis. Can you assist with any approach of how to do this..?

Thanks in advance

Koteswar

Re: To move the calculations in Master measures to data load editor

AG-gugelbisolutions — Wed, 09 Feb 2022 15:23:32 GMT

I don't think there is any easy and straightforward solution, I'm afraid.

However, as a general rule of thumb, you could, for example, translate if and set-analysis to flags so that your measures get at least simpler.

Could you provide us with an example?

Re: To move the calculations in Master measures to data load editor

AG-gugelbisolutions — Wed, 09 Feb 2022 17:05:38 GMT

I'm afraid you cannot bring to the script this kind of conditions. The point is that the result depends on current selections.

What you could try in order to optimize performance is to put the "count(...)=1 and count(...)>=1" condition in a variable with the = sign at the beginning, but it will work only if this condition is used all over the places in th application.

Re: To move the calculations in Master measures to data load editor

Koti_Ch — Thu, 10 Feb 2022 06:18:03 GMT

Thank you.