HELP Please! VAR DAX

[Anonymous]

Hi There,

I am trying to replicate a formula I found on youtube but without success, would anyone know how to solve the problem

Formula that I am trying to copy:

Running Total = VAR ThisHeaderID = SELECTEDVALUE(Header[Header Sort])

                                VAR Result = CALCULATE([Magic Additive Total], ALL(Header), Header[Header Sort] <= ThisHeader ID)

                                RETURN Result

My formula:

Group Running Total = VAR GroupID = SELECTEDVALUE('Account & Account Group'[Groupp ID])

*I know the last 'Groupp ID' spelt wrong but I did it wrong in Excel so I just leave it

[PhilipTreacy]

Hi @Anonymous 

I'm perplexed as to what I've missed.  Was there something wrong with the answer I supplied on Friday?  Which says the same as the answer you accepted that was posted just a few hours ago?

Regards

Phil

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your DAX formula and error message, I think the true reason for this problem is that you didn’t use “return” to return the value you want the measure to return. Because if you used the “VAR” statement to define a variable, you have to use the "return" to return the result. You can try to change the DAX formula like this:

Grouping Running Total=
VAR GroupID=SELECTVALUE(‘Account & Account Group’[Group ID])
return
GroupID

More detail about “VAR” in DAX

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PhilipTreacy]

Hi @Anonymous 

When you use VAR in  a measure you must use RETURN to return a value.  In this instance you don't need either VAR or RETURN, the measure can be simplified.

So the correct syntax is

Group Running Total = SELECTEDVALUE('Account & Account Group'[Groupp ID])

regards

Phil