Two column from two different field to multiple

[abc_777]

I want to multiple one column table with one of my measure

In my Measure I do Quantity * Unit Price and these column are in same table

I do Average, MIN, and MAX but its giving me wrong answer

Result= Measure * AVERAGE(Table B [Column])

Result= Measure * MIN(Table B [Column])

Result= Measure * MAX(Table B [Column])

but here if you give me solution how to multiple two column from two different table I thing it will work. (Without MIN, MAX, Average)

what is the solution

Table A
12
3
4
5
6
14
7

Multiple *

Table B
3
14
15
2
5
8
5

[amitchandak · Accepted solution]

@abc_777 , When you do the product of two numbers, you need to do it at row level or some common group level.

You need use values or summarize from same column

Tab has [Column] common from A and B Joined on column

example 

sumx( values(Tab[Column]), calculate(Sum(TableA[Value]) * Sum(TableB[Value])))

[abc_777]

thanks amit, actually i had relation or data modeling issue. Fixed it. thank you so much. I also keep this calculation in my note.