Forum Discussion

ronnie_roberts's avatar
ronnie_roberts
Icon for Helper I rankHelper I
23 days ago
Solved

SUMX Not Working

I have created a sample dashboard based on the AdventureWorks sample database and I cannot figure out why I cannot get this to work.  I can evaluate every VAR throughout except _Result which never wo...
  • Shai_Karmani's avatar
    Shai_Karmani
    23 days ago

    Your query is correct up until EVALUATE. The issue is that EVALUATE expects a table expression, and _Result is a scalar, so the engine cannot return it. Wrap it in either curly braces or ROW and it will work.

    EVALUATE { _Result }

    or

    EVALUATE ROW("Result", _Result)

    Once you do that you should see the Accessories 2011 total returned as a single row.

     

    If this helped, a thumbs up and accepting the solution would be appreciated.

     

    Thanks,
    Shai Karmani

Shai_Karmani's avatar
Shai_Karmani
Icon for Super User rankSuper User
23 days ago

Your query is correct up until EVALUATE. The issue is that EVALUATE expects a table expression, and _Result is a scalar, so the engine cannot return it. Wrap it in either curly braces or ROW and it will work.

EVALUATE { _Result }

or

EVALUATE ROW("Result", _Result)

Once you do that you should see the Accessories 2011 total returned as a single row.

 

If this helped, a thumbs up and accepting the solution would be appreciated.

 

Thanks,
Shai Karmani