Forum Discussion
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 ...
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 , 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])))
thanks amit, actually i had relation or data modeling issue. Fixed it. thank you so much. I also keep this calculation in my note.