Let and inline

[louise119]

I wanna make table like below.
But the variables are empty.
Does anyone know what is wrong?

Let vA = Sum([Field]);
Let vB = Sum([Field]);

Table1:
LOAD * Inline
[
column1,column2
aaa,$(vA)
bbb,$(vB)
];

Thank you.

[Aurelien_Martinez]

Hi,

Set vA = Sum([Field]);
Set vB = Sum([Field]);

Table1:
LOAD 
  column1,
  Replace(column2, '%', '$') as column2
Inline
[
column1,column2
aaa,%(=%(vA))
bbb,%(=%(vB))
];

[louise119]

Thank you.
But I couldn't get the value of column2...

 

[Aurelien_Martinez · Accepted solution]

Ok,

Set vA = Sum(Field);
Set vB = Sum(Field);

Load
  *
Inline [
  Field
  10
  20
];

Table1:
LOAD 
  column1,
  Replace(column2, '%', '$') as column2
Inline
[
column1,column2
aaa,$(vA)
bbb,$(vB)
];

And the expression :

[louise119]

Thank you so much.
I copied your script and excuse, but I couldn't get the value...

 

[Aurelien_Martinez]

You need to create a measure like : $(=Only(column2))

[louise119]

Thank you so much.
I can get the value when the field name is same.

I wanna use different field name like below,

Set vA = Sum(Field_1);
Set vB = Sum(Field_2);

But in this case, I can't get the value. 

[Aurelien_Martinez]

I found a problem when vA and vB are not the same 😱

Pick(Match(column1, 'aaa', 'bbb'), $(=Only({<column1={'aaa'}>} column2)), $(=Only({<column1={'bbb'}>} column2)))

[louise119]

Thank you so much🙏

I solve the problem!
and I got the same value with your script.