Forum Discussion
abc_777
Solution Specialist
Solution SpecialistTwo 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 ...
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])))
amitchandak
Super User
Super Userabc_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_777Solution Specialist
Solution Specialistthanks amit, actually i had relation or data modeling issue. Fixed it. thank you so much. I also keep this calculation in my note.