Couldnot load the Visual, "The XML for Analysis request timed out before it was completed. "

[Anonymous]

Trying to add the one calculated Measure in a table view as a column. Where in that Table view having many columns and i am just trying to add the calculated measure column in that Table view. But i am getting the error like 
Error : OLE DB or OBDC error: the xml for analysis request timed out before it was completed, timeout value 225 sec. 

But when i am trying to add this column separately, the column we are able to load.
is it becoz of  the calculation of the  Measure, this is the measure 
 Measure_TEST =
var earlyClassificationID = SELECTEDVALUE(TABLE_A[ID])
var earlyClassificationNum = LOOKUPVALUE(LOOKUP_TABLE[Number],LOOKUP_TABLE[Id],earlyClassificationID)
var finalClassificationNum = SELECTEDVALUE(TABLE_B[Value])
var resultClassificationID = COALESCE(finalClassificationNum,earlyClassificationNum)
var resultClassDesc = LOOKUPVALUE(LOOKUP_TABLE[Description],LOOKUP_TABLE[Number],resultClassificationID)
return resultClassDesc.

Please provide the inputs for this issue to solve.

[Anonymous]

@RossEdwards, i have checked the relations, Relations were as expected but the data model is having an large data
What will be the other suggestions to overcome the issue?

[Anonymous]

@RossEdwards Yes, it is a Star schema, Eack lookup tables consists the values of around 150 - 200 records.

[RossEdwards]

Has each of your table relationships (Dim to fact) been set up as a 1:Many relationship with only a Single Direction filtering?

I've seen some terrible models in my time where people turn on Bi-Directional filtering across an entire model.

[RossEdwards]

See if this performs better:

 Measure_TEST =
var earlyClassificationID = SELECTEDVALUE(TABLE_A[ID])
var earlyClassificationNum = CALCULATE(SELECTEDVALUE(LOOKUP_TABLE[Number]), LOOKUP_TABLE[Id] = earlyClassificationID)
var finalClassificationNum = SELECTEDVALUE(TABLE_B[Value])
var resultClassificationID = COALESCE(finalClassificationNum,earlyClassificationNum)
var resultClassDesc = CALCULATE(SELECTEDVALUE(LOOKUP_TABLE[Description]),LOOKUP_TABLE[Number] = resultClassificationID)
return resultClassDesc.

[Anonymous]

@RossEdwards , i modified the measure  and tried to add it as a column,  but still facing the same issue.

[RossEdwards]

This suggests to me that your model is the problem here.  Is your model set up as a star schema?  How many records are in some of these lookup tables?