Forum Discussion
ronnie_roberts
Helper I
Helper ISUMX 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...
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
ronnie_robertsHelper I
Helper IDarn it. I spent 4 hours troubleshooting that yesterday! I even kept seeing people using {} in EVALUATE and I couldn't figure out why.
Many thanks