Total of conditional measures with multiple tables

[Anonymous]

Hello,

I'm simply trying to find an efficient way to calculate the grand total of a column with conditional measures.

In this particular case we have May and June sales data in 2 different tables which are joined by the country column. When June data are missing , the blank cells are calculated using the May data. (june sales = may sales x 0.5). (see below)

The problem is that the total ($10000) of the "Calculated Junes Sales" column is wrong. I have tried to used SUMX to resolved this issue with no success. The difficulty comes from the fact that May and June data are in 2 different tables.

Thank you for your help.

[amitchandak]

@Anonymous , Assume you have measure [May Sales], Try like

sumx(Values(Table[Country]), [May Sales]* .5)