Forum Discussion

lawadaa's avatar
lawadaa
Helper I
2 years ago

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

quizzes % = calculate(IF(MIN('Agents list'[Position])="Retail Sales Agent",SUM(Quizzes[Percentage])*.05,IF(MIN('Agents list'[Position])="Retail Sales Supervisor",SUM(Quizzes[Percentage]))*.02))
 
RQMs % = calculate(IF(MIN('Agents list'[Position])="Retail Sales Agent",SUM(RQMS[Percentage])*.05,IF(MIN('Agents list'[Position])="Retail Sales Supervisor",SUM(RQMS[Percentage])*.02)))
 
30% average achievement total = SWITCH(TRUE(),[Average Achievement total]>1.0000,.30000,.3*[Average Achievement total])
30% net branch total achievement = SWITCH(TRUE(),[net branch achievement%]>1.0000,.30000,.3*[net branch achievement%])
core achievement = IF(MIN('sales agents rotation'[Position])="Retail Sales Agent",[Achievement monthly]*.8,IF(MIN('sales agents rotation'[Position])="Retail Sales Supervisor",[Achievement monthly]*.32))

 
accessories achiev partial% = IF(MIN('Agents list'[Position])="Retail Sales Agent",IF([accessories achiev%]>1.0000,.10000,.1*[accessories achiev%]),IF(MIN('Agents list'[Position])="Retail Sales Supervisor",IF([accessories achiev%]>1.0000,.040000,.04*[accessories achiev%])))

 

1 Reply

  • Use Performance Analyzer.  Grab the query for the visual. Examine the query in DAX Studio.  Refactor the query.