How to multiply two columns in separate tables

[Anonymous]

Hi,

I have two tables :

• IRG_ANALYSIS : contains the total of each line
• IRG_CODES : contains the 'rate' (taux)

They are linked by a merged column

IRG_ANALYSIS table :

IRG_CODE table : 

 When I select my columns, the rate is correctly displayed ("TAUX" column) :

I would like to multiply "total" by "taux".

I tested this :

TotalIRG = CALCULATE( (SUM(IRG_ANALYSIS[Total]) * (SUM(IRG_CODES[TAUX])) /100 )
)

But the result is not correct : 42 insted of 21.15 (52.87 * 40/100 = 21.15)

Thanks for your help. 

[Anonymous · Accepted solution]

Solved by using :

TotalIRG =
SUMX ( IRG_ANALYSIS, IRG_ANALYSIS[Total] * RELATED ( IRG_CODES[TAUX] ) / 100 )

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Hi @amitchandak 

I updated my post, something wrong happened (every screenshots have been deleted ..)

Thanks