CALCULATETABLE with multiple filter

Hi F75,

If there are only a few columns in Input Table, like [2017 Plan A] and [2017 Plan B], you can use below formula to create a calculate column in Data Table.

New Unit Price =
IF (
    Data[Scenario] = "2017 Plan A",
    LOOKUPVALUE ( Input[2017 Plan A], Input[Account], Data[Account] ),
    IF (
        Data[Scenario] = "2017 Plan B",
        LOOKUPVALUE ( Input[2017 Plan B], Input[Account], Data[Account] ),
        BLANK ()
    )
)

However, if there are many columns in Input Table in query editor, you should first unpivot it to get below format.

Then, in modeling mode, based on above table, please create a new table.

Table =
UNION (
    SELECTCOLUMNS (
        'Input (2)',
        "Account", 'Input (2)'[Account],
        "Plan", 'Input (2)'[Attribute],
        "Value", 'Input (2)'[Value]
    ),
    SELECTCOLUMNS (
        'Input (2)',
        "Account", 'Input (2)'[Account],
        "Plan", 'Input (2)'[Attribute.1],
        "Value", 'Input (2)'[Value.1]
    )
)

Then, in Data Table, create a calculated column.

New Unit Price 2 =
LOOKUPVALUE (
    'Table'[Value],
    'Table'[Account], Data[Account],
    'Table'[Plan], Data[Scenario]
)

Best regards,
Yuliana Gu