Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
helHello, I have the following problem.
I have the following formula, which is giving me the correct result, the drawback is that the performance is very slow. I would like to know if I have any way to optimize the performance of my measure. It is a very long formula so I could not add it to the publication, I leave a link with notepad that contains my measurement.
Solved! Go to Solution.
A quick win would be to use variables to store the results of calculations which are currently being done multiple times. e.g.
CALCULATE (
SUM ( Worksheet[LE Volume] ),
ALLSELECTED ( Worksheet ),
VALUES ( Worksheet[Month] ),
VALUES ( Worksheet[Category] )
)
is done multiple times and must be calculated every time. Store the result in a variable so you only have to do the calculation once.
Hi @mlozano
1. Must the measure be that long?
2. Have you removed all duplication from it?
3. Instead of IF's, have you tried to use SWITCHes?
4. Have you tried to optimize each small piece of the measure so that it's fast when applicable?
5. The problem is that if you have many variables calculated outside of IF/SWITCH, then DAX very often, or even 95%+ of the time, will try to calculate EVERYTHING regardless of whether a variable will or will not be needed for the final calculation. Therefore it's so important to place the calculation of variables in the correct places, that is under IF/SWITCH.
Hi @mlozano
1. Must the measure be that long?
2. Have you removed all duplication from it?
3. Instead of IF's, have you tried to use SWITCHes?
4. Have you tried to optimize each small piece of the measure so that it's fast when applicable?
5. The problem is that if you have many variables calculated outside of IF/SWITCH, then DAX very often, or even 95%+ of the time, will try to calculate EVERYTHING regardless of whether a variable will or will not be needed for the final calculation. Therefore it's so important to place the calculation of variables in the correct places, that is under IF/SWITCH.
A quick win would be to use variables to store the results of calculations which are currently being done multiple times. e.g.
CALCULATE (
SUM ( Worksheet[LE Volume] ),
ALLSELECTED ( Worksheet ),
VALUES ( Worksheet[Month] ),
VALUES ( Worksheet[Category] )
)
is done multiple times and must be calculated every time. Store the result in a variable so you only have to do the calculation once.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |