Forum Discussion
cant resolve error visual has exceeded available resources
hello
I'm trying to create a measure that calculate % from another measures. the idea is a performance measure consists of 5 KPIs with each having a weight percentage
for ex. perfomance measue =
10%*Core achievement
35%*non core achievement
20%* branch sales
15%* average indivisual sales agent achievement
10%* accessories sales
performance measure is then the sum of all the 5 KPI multiplied by their percentage . Each KPI is created in a measure and the final measure will take 5 measures and multiply them by the percentage weight
i created the measure mentioned in the screenshot but once i added it to the visual it's giving the error 'visual has exceeded available resources'. i tried to reduce measures inside the performance measure from 5 to 3 and it worked but i keep it to 4 or 5 measures it gives me again the same error.
how can i get the same result from the this measure without having the error of visual exceeded available resources
the measures i created and added in the performance measure are as below
1 Reply
- lbendlinSuper User
Use Performance Analyzer. Grab the query for the visual. Examine the query in DAX Studio. Refactor the query.