Measure to Mutliple two columns from different Tables

[Mavericks334]

Hi,

I have Table A and Table B

Below are the details of the table.
[TABLE="width: 59"]
<COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><TBODY>[TR]
[TD="class: xl65, width: 78, bgcolor: transparent"]Complexity[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]5[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]7[/TD]
[/TR]
</TBODY>[/TABLE]


Table B has [TABLE="width: 107"]
<COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2852" width=78><COL style="WIDTH: 48pt" width=64><TBODY>[TR]
[TD="class: xl65, width: 78, bgcolor: transparent"]Complexity[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Time[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]10[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]15[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]20[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]25[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]30[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]35[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]40[/TD]
[/TR]
</TBODY>[/TABLE]

There is a relationship between Table A & B.

I need to created a measure that would calculate Table A [Complexity]*Table[Time]

I am able to do this with an additional column in table A by using related, i dont wish to do that, need to create a measure so the size of the sheet would reduce.

 

[Laurent C]

I got confused by the number of digits in your results as opposed to the formatting of the normalized times ...
... and also by the layout of my own pivot table

The following measure will look at every row within the current context and will add up the normalized times:
Measure :=SUMX(YourDataTable,
RELATED(YourLookupTable[Times Complexity 1])
)

 

[Mavericks334]

Thanks will try it out

 

[Mavericks334]

This is the error i get.

The value for column 'Fund_Complexity' in table 'SharePoint Data' cannot be determined in the current context. Check that all columns referenced in the calculation expression exist, and that there are no circular dependencies.

 

[Laurent C]

I am pretty sure I did not include 'Fund_Complexity' in my suggestion

Measure :=SUMX('Sharepoint Data',
RELATED(YourLookupTable[Times Complexity 1])
)

 

[Mavericks334]

ok let me just try with the table, misunderstood, i used even the column name

 

[Mavericks334]

It Worked. How do i sum mutliple columns together,

=Calculate(Sumx(Table),Calculate(Sumx(Table))

 

[Laurent C]

Such a measure will be a problem.

If you must add two columns then just reference them in your expression:
Table1[Column1] + Table1[Column2]