multiply two columns from diferent table

[madji]

HI

I have one problem with dax.

How can I  multiply two cells from different table

For example I want to get A*B. it work, but for total is not correct.  I want to see sum 50 + 1400 

[madji]

https://community.powerbi.com/t5/Desktop/Create-a-Calculated-Column-from-Different-Tables/m-p/60773#...

[Greg_Deckler]

See this post:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

[madji]

https://yadi.sk/d/OwlJzzG33QPaZV

Link to my examle.

And I think  total is not correct.  I want to see sum 50 + 1400 

[v-jiascu-msft · Accepted solution]

Hi @madji,

Maybe you can try this formula.

Measure1 =
IF (
    HASONEFILTER ( Table1[Column1] ) || HASONEFILTER ( Table2[Column1] ),
    SUM ( Table1[A] ) * SUM ( Table2[B] ),
    SUMX (
        SUMMARIZE (
            'Table1',
            'Table1'[Column1],
            'Table1'[A],
            'Table2'[B],
            "product", 'Table1'[A] * 'Table2'[B]
        ),
        [product]
    )
)

Best Regards,

Dale

[madji]

Thanks a lot 😃 

It is really amazing) 

[v-jiascu-msft]

Hi @madji,

You are welcome. I just realized it could be simpler in your scenario. Please try this one.

Measure3 = sumx(
	SUMMARIZE('Table1',
			'Table1'[Column1],
			'Table1'[A],
			'Table2'[B],
			"product", 'Table1'[A] * 'Table2'[B]),
			[product])

Best Regards,

Dale