Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
for me it works, have a look at the attachment...
try
=$(vVariable)
Hi Robin,
Thanks for the reply,
I am getting the same result if I use $(vVariable)
for me it works, have a look at the attachment...
Check this out.
If it's not $(vVariable), then it's something to do with your joins in your data model
Hi,
Thanks to all it worked ,
The mistake i did is =sum(Sales) in vVariable , it should be sum(Sales)