Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
5 years ago
Solved

Two column from two different field to multiple

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
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    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])))

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    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's avatar
      abc_777
      Solution Specialist
      5 years ago

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