I am receiving an error:
An unexpected error occurred (file 'xlrellogop.cpp', line 3128, function 'XLLogOp_SPJ<class XLScaLogOp>::ExecSpool')
It happens in any of several (but not all) measures that:
- reference another measure in a VAR assignment
- the main measure is used in a Table visualization
- same measure works fine in a Card visualization on the same page
- same measure works fine in DAX Studio
Here is the general pattern. Main measure starts out like this pseudo code:
RWB: =
row("foo1", switch(true()
, [very expensive measure] = 0, "red"
, [very expensive measure] = 1, "white"
, [very expensive measure] = 2, "blue"
)
)
Assume this measure works just fine. Reference it in a Power BI 'Table', in a 'Card', either works fine.
But wait a minute! We could end up calling the [very expensive measure] 3 times...why not use a VAR?
RWB: =
var VEM = [very expensive measure]
return
row("foo1", switch(true()
, VEM = 0, "red"
, VEM = 1, "white"
, VEM = 2, "blue"
)
)
It runs much faster now in DAX Studio! Let's deploy it to the SSAS Datatabase. Let's refresh the Power BI document. The Card that refers to [RWB] works. Table that refers to [RWB] has a big X on it. Details shows:
An unexpected error occurred (file 'xlrellogop.cpp', line 3128, function 'XLLogOp_SPJ<class XLScaLogOp>::ExecSpool')
I have to go back to the slow version - with redundant calls to [very expensive measure] - to get the page working again.
Thoughts?
