Forum Discussion
Combining Table
From what your describing, it suonds like you need a calculated column, not a calulcated measure.
Calculated Column: T1Pack = RELATED(Table2[T1Pack])
Calculated Measure: Just use whatever aggregation you need in the DAX expression (e.g. SUM(T1Pack))
Please note that both the approaches assume that there is relationship/join between the two tables.
If you take a look at the picture below,
I have two tables, with what I described earlier.
I wish to create a measure such that it relate the values between the two table, and from the value in [T1Pack] i wish to minus the value from another measure [PBI(Average) Time]
[PBI(Average) Time] is a measure and T1Pack looks like a column with text values. How do you intend to do the subtraction?
Table ENGG VW_TRM and Table TRM Tk1 Pack CTL#7 have related columns (Strategy), (Repair Scheme) , (Engine Type) and (Package). Table TRM Tk1 Pack CTL #7 has the column named (T1Pack) which has the values I want.
As my previous measures are based off the columns in ENGG VW_TRM table, I wish to create a measure to grab the values in TRM Tk1 Pack CTL #7 table by cross-checking the related columns and then use that data to minus off the values in the measure [Average Time] to get the calculations.
It would be much easier if you posted sample data (not images) from both tables. You can create the data in Excel and just paste it in you post.
