Forum Discussion
Solved
Visual has exceeded the available resources - How to optimize this measure
I have the issue for 'Visual has exceeded the available'. Probably due to I have several columns with little complex measures in a matrix. I learned online that we should try to use variable to ...
Hi emmalim ,
You can try the following dax
Measure = CALCULATE( [VpL_Cm], FILTER(ALL('P&L_ROW'),'P&L_ROW'[PL_ROW] in {"Net Sales","Cost of sales"}))Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi emmalim ,
You can try the following dax
Measure =
CALCULATE(
[VpL_Cm],
FILTER(ALL('P&L_ROW'),'P&L_ROW'[PL_ROW] in {"Net Sales","Cost of sales"}))
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.