Forum Discussion
ephramz
Helper II
Helper IICombining Table
I have two tables 1) Table 1 Column name: (Strategy), (Repair Scheme), (Engine Type), (Package), and otehr columns 2)Table 2: Column name: (Strategy), (FRS), (EngType), (Package Code), and oteh...
Shahfaisal
Solution Sage
Solution SageFrom 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.
ephramzHelper II
Helper IIIf 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]