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.
