How to calculate dimension using two fields from different tables?

[paweln]

Dear All,

I would like to have new field in table "Inspekcje". 

If(sum([Ilość Defektu])>0, 'Y', 'N') as "With defects"

but field [Ilośc Defektu] comes from different table then the one that should have "With defects" field.

There may be many records with the same REF in "Defekty". REF is unique in "Inspekcje".

How to do it in the script?

[Taoufiq_Zarra]

can you share a sample data and the output ?

[paweln]

This is example data.

I would like to have table like this:

where last dimension is calculated in the script. "Y" if pcs*weight > 3000.

How the cript should look like when I want to multiply fields from two different tables?

[arulsettu]

Is this your expected output?

[paweln]

Basically Yes. Only I need that as a dimension not a measure.

[NitinK7]

Hi,

Write calculated dimension like

=if((pcs*WEIGHT)>3000,'Y','N')

[arulsettu]

we can use the same logic in Dimension

[Kushal_Chawda · Accepted solution]

try below

Map_Weight:
mapping LOAD
    SIZE,
    WEIGHT
FROM [lib://Data/two tables.xlsx]
(ooxml, embedded labels, table is Arkusz3);

Data:
LOAD
    ID,
    SIZE,
    pcs,
    if(pcs*ApplyMap('Map_Weight',SIZE,0)>3000,'Y','N') as [Target Achieved]
FROM [lib://Data/two tables.xlsx]
(ooxml, embedded labels, table is list);