Home Forums Data Warehousing Analysis Services Tabular using DAX: Possible to lookup across multiple tables (LOOKUPVALUE or CALCULATE?) RE: Tabular using DAX: Possible to lookup across multiple tables (LOOKUPVALUE or CALCULATE?)

  • You could pull through the StateID or StateName as a calculated column into the Employee table using the formula below. Then you should be able to filter as you need.

    =RELATED(State[StateID])

    Though I agree with the previous comment, that you havent provided enough context of the issue.

    Thanks