Reusable Expression in variable

[Anonymous]

Hi Al,

Please let me know how to use reusable expression in variable.

Example

LOAD * INLINE [
Country, Sales, Region , Year
A, 10, A1, 2017
B, 20, B1, 2017
C, 30, C1, 2017
A, 101, A1, 2016
B, 201, B1, 2016
C, 301, C1, 2016

];

I used Sum(Sales) in variable (vVariable) , but I am getting the result like the below one

Expression : =vVariable

[Anonymous]

try

=$(vVariable)

[Anonymous]

Hi Robin,

Thanks for the reply,

I am getting the same result if I use $(vVariable)

[Anonymous · Accepted solution]

for me it works, have a look at the attachment...

[neelamsaroha157]

Check this out.

[vicobi123]

If it's not $(vVariable), then it's something to do with your joins in your data model

[Anonymous]

Hi,

Thanks to all it worked ,

The mistake i did is =sum(Sales) in vVariable , it should be sum(Sales)