xlrellogop.cpp

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?