Union between 2 semantic models

Question

I am trying to create a DAX on Union of 2 existing semantic models but am running into an error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."&nbsp;I have matched the columns from both semantic model &amp; ensured are having same number of columns &amp; names.&nbsp;Below is the union&nbsp;UnionTable =UNION(&nbsp; &nbsp; SELECTCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; FX_Data_2022_Onwards,&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_DATE_NEW", FX_Data_2022_Onwards[TRAN_DATE], &nbsp;// TRAN_DATE_NEW aligned&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_DATE_OLD", FX_Data_2022_Onwards[VALUE_DATE], // TRAN_DATE_OLD aligned&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_ID", FX_Data_2022_Onwards[TRAN_ID],&nbsp; &nbsp; &nbsp; &nbsp; "PART_TRAN_TYPE", FX_Data_2022_Onwards[PART_TRAN_TYPE],&nbsp; &nbsp; &nbsp; &nbsp; "GL_SUB_HEAD_CODE", FX_Data_2022_Onwards[GL_SUB_HEAD_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "CIF No", FX_Data_2022_Onwards[CIF No],&nbsp; &nbsp; &nbsp; &nbsp; "Customer Name", FX_Data_2022_Onwards[Customer Name],&nbsp; &nbsp; &nbsp; &nbsp; "FORACID", FX_Data_2022_Onwards[FORACID],&nbsp; &nbsp; &nbsp; &nbsp; "VALUE_DATE", FX_Data_2022_Onwards[VALUE_DATE],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_PARTICULAR", FX_Data_2022_Onwards[TRAN_PARTICULAR],&nbsp; &nbsp; &nbsp; &nbsp; "REF_NUM", FX_Data_2022_Onwards[REF_NUM],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_RMKS", FX_Data_2022_Onwards[TRAN_RMKS],&nbsp; &nbsp; &nbsp; &nbsp; "PSTD_DATE", FX_Data_2022_Onwards[PSTD_DATE],&nbsp; &nbsp; &nbsp; &nbsp; "Time", FX_Data_2022_Onwards[Time],&nbsp; &nbsp; &nbsp; &nbsp; "RATE_CODE", FX_Data_2022_Onwards[RATE_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "RATE", FX_Data_2022_Onwards[RATE],&nbsp; &nbsp; &nbsp; &nbsp; "CRNCY_CODE", FX_Data_2022_Onwards[CRNCY_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_CRNCY_CODE", FX_Data_2022_Onwards[TRAN_CRNCY_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_AMT", FX_Data_2022_Onwards[TRAN_AMT],&nbsp; &nbsp; &nbsp; &nbsp; "REF_CRNCY_CODE", FX_Data_2022_Onwards[REF_CRNCY_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "REF_AMT", FX_Data_2022_Onwards[REF_AMT],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_AMT_AED", FX_Data_2022_Onwards[TRAN_AMT_AED],&nbsp; &nbsp; &nbsp; &nbsp; "TREA_RATE", FX_Data_2022_Onwards[TREA_RATE],&nbsp; &nbsp; &nbsp; &nbsp; "CCY SLABS", FX_Data_2022_Onwards[CCY SLABS],&nbsp; &nbsp; &nbsp; &nbsp; "Type", FX_Data_2022_Onwards[Type],&nbsp; &nbsp; &nbsp; &nbsp; "MID Rate in USD", FX_Data_2022_Onwards[MID Rate in USD],&nbsp; &nbsp; &nbsp; &nbsp; "Ccy pair", FX_Data_2022_Onwards[Ccy pair],&nbsp; &nbsp; &nbsp; &nbsp; "Base currency", FX_Data_2022_Onwards[Base currency],&nbsp; &nbsp; &nbsp; &nbsp; "Base currency Amount", FX_Data_2022_Onwards[Base currency Amount],&nbsp; &nbsp; &nbsp; &nbsp; "Tran rate (1 Base ccy = x Other ccy)", FX_Data_2022_Onwards[Tran rate(1 Base ccy = x Other ccy)],&nbsp; &nbsp; &nbsp; &nbsp; "Check", FX_Data_2022_Onwards[Check],&nbsp; &nbsp; &nbsp; &nbsp; "Other Ccy", FX_Data_2022_Onwards[Other Ccy],&nbsp; &nbsp; &nbsp; &nbsp; "Other Ccy Amount", FX_Data_2022_Onwards[Other Ccy Amount],&nbsp; &nbsp; &nbsp; &nbsp; "REVERSAL", FX_Data_2022_Onwards[REVERSAL],&nbsp; &nbsp; &nbsp; &nbsp; "Buy/Sell", FX_Data_2022_Onwards[Buy/Sell],&nbsp; &nbsp; &nbsp; &nbsp; "Derived real-time rate", FX_Data_2022_Onwards[Derived real-time rate],&nbsp; &nbsp; &nbsp; &nbsp; "Currency other than AED", FX_Data_2022_Onwards[Currency other than AED],&nbsp; &nbsp; &nbsp; &nbsp; "Amount other than AED", FX_Data_2022_Onwards[Amount other than AED],&nbsp; &nbsp; &nbsp; &nbsp; "Seg profit 1", FX_Data_2022_Onwards[Seg profit 1],&nbsp; &nbsp; &nbsp; &nbsp; "Real time profit-1", FX_Data_2022_Onwards[Real time profit-1],&nbsp; &nbsp; &nbsp; &nbsp; "Currency other than USD", FX_Data_2022_Onwards[Currency other than USD],&nbsp; &nbsp; &nbsp; &nbsp; "Amount other than USD", FX_Data_2022_Onwards[Amount other than USD],&nbsp; &nbsp; &nbsp; &nbsp; "Seg profit 2", FX_Data_2022_Onwards[Seg profit 2],&nbsp; &nbsp; &nbsp; &nbsp; "Real time profit-2", FX_Data_2022_Onwards[Real time profit-2],&nbsp; &nbsp; &nbsp; &nbsp; "Segment Profit (AED)", FX_Data_2022_Onwards[Segment Profit(AED)],&nbsp; &nbsp; &nbsp; &nbsp; "Profit w.r.t real time rate (AED)", FX_Data_2022_Onwards[Profit w.r.t real time rate(AED)],&nbsp; &nbsp; &nbsp; &nbsp; "Difference", FX_Data_2022_Onwards[Difference],&nbsp; &nbsp; &nbsp; &nbsp; "GL Segment", FX_Data_2022_Onwards[GL Segment],&nbsp; &nbsp; &nbsp; &nbsp; "GL Subsegment", FX_Data_2022_Onwards[GL Subsegment],&nbsp; &nbsp; &nbsp; &nbsp; "Sol ID", FX_Data_2022_Onwards[Sol ID],&nbsp; &nbsp; &nbsp; &nbsp; "SOL Desc", FX_Data_2022_Onwards[SOL Desc],&nbsp; &nbsp; &nbsp; &nbsp; "RM Name", FX_Data_2022_Onwards[RM Name],&nbsp; &nbsp; &nbsp; &nbsp; "DELIVERY_CHANNEL_ID", FX_Data_2022_Onwards[DELIVERY_CHANNEL_ID],&nbsp; &nbsp; &nbsp; &nbsp; "Source", "FX_Data_2022_Onwards"&nbsp; &nbsp; ),&nbsp; &nbsp; SELECTCOLUMNS(&nbsp; &nbsp; &nbsp; &nbsp; RMT_CPR,&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_DATE_NEW", RMT_CPR[VALUE_DATE], // Match the first table's TRAN_DATE_NEW&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_DATE_OLD", RMT_CPR[TRAN_DATE], // Match the first table's TRAN_DATE_OLD&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_ID", RMT_CPR[TRAN_ID],&nbsp; &nbsp; &nbsp; &nbsp; "PART_TRAN_TYPE", RMT_CPR[PART_TRAN_TYPE],&nbsp; &nbsp; &nbsp; &nbsp; "GL_SUB_HEAD_CODE", RMT_CPR[GL_SUB_HEAD_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "CIF No", RMT_CPR[CIF No],&nbsp; &nbsp; &nbsp; &nbsp; "Customer Name", RMT_CPR[Customer Name],&nbsp; &nbsp; &nbsp; &nbsp; "FORACID", RMT_CPR[FORACID],&nbsp; &nbsp; &nbsp; &nbsp; "VALUE_DATE", RMT_CPR[VALUE_DATE],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_PARTICULAR", RMT_CPR[TRAN_PARTICULAR],&nbsp; &nbsp; &nbsp; &nbsp; "REF_NUM", RMT_CPR[REF_NUM],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_RMKS", RMT_CPR[TRAN_RMKS],&nbsp; &nbsp; &nbsp; &nbsp; "PSTD_DATE", RMT_CPR[PSTD_DATE],&nbsp; &nbsp; &nbsp; &nbsp; "Time", RMT_CPR[Time],&nbsp; &nbsp; &nbsp; &nbsp; "RATE_CODE", RMT_CPR[RATE_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "RATE", RMT_CPR[RATE],&nbsp; &nbsp; &nbsp; &nbsp; "CRNCY_CODE", RMT_CPR[CRNCY_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_CRNCY_CODE", RMT_CPR[TRAN_CRNCY_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_AMT", RMT_CPR[TRAN_AMT],&nbsp; &nbsp; &nbsp; &nbsp; "REF_CRNCY_CODE", RMT_CPR[REF_CRNCY_CODE],&nbsp; &nbsp; &nbsp; &nbsp; "REF_AMT", RMT_CPR[REF_AMT],&nbsp; &nbsp; &nbsp; &nbsp; "TRAN_AMT_AED", RMT_CPR[TRAN_AMT_AED],&nbsp; &nbsp; &nbsp; &nbsp; "TREA_RATE", RMT_CPR[TREA_RATE],&nbsp; &nbsp; &nbsp; &nbsp; "CCY SLABS", RMT_CPR[CCY SLABS],&nbsp; &nbsp; &nbsp; &nbsp; "Type", RMT_CPR[Type],&nbsp; &nbsp; &nbsp; &nbsp; "MID Rate in USD", RMT_CPR[MID Rate in USD],&nbsp; &nbsp; &nbsp; &nbsp; "Ccy pair", RMT_CPR[Ccy pair],&nbsp; &nbsp; &nbsp; &nbsp; "Base currency", RMT_CPR[Base currency],&nbsp; &nbsp; &nbsp; &nbsp; "Base currency Amount", RMT_CPR[Base currency Amount],&nbsp; &nbsp; &nbsp; &nbsp; "Tran rate (1 Base ccy = x Other ccy)", RMT_CPR[Tran rate(1 Base ccy = x Other ccy)],&nbsp; &nbsp; &nbsp; &nbsp; "Check", RMT_CPR[Check],&nbsp; &nbsp; &nbsp; &nbsp; "Other Ccy", RMT_CPR[Other Ccy],&nbsp; &nbsp; &nbsp; &nbsp; "Other Ccy Amount", RMT_CPR[Other Ccy Amount],&nbsp; &nbsp; &nbsp; &nbsp; "REVERSAL", RMT_CPR[REVERSAL],&nbsp; &nbsp; &nbsp; &nbsp; "Buy/Sell", RMT_CPR[Buy/Sell],&nbsp; &nbsp; &nbsp; &nbsp; "Derived real-time rate", RMT_CPR[Derived real-time rate],&nbsp; &nbsp; &nbsp; &nbsp; "Currency other than AED", RMT_CPR[Currency other than AED],&nbsp; &nbsp; &nbsp; &nbsp; "Amount other than AED", RMT_CPR[Amount other than AED],&nbsp; &nbsp; &nbsp; &nbsp; "Seg profit 1", RMT_CPR[Seg profit 1],&nbsp; &nbsp; &nbsp; &nbsp; "Real time profit-1", RMT_CPR[Real time profit-1],&nbsp; &nbsp; &nbsp; &nbsp; "Currency other than USD", RMT_CPR[Currency other than USD],&nbsp; &nbsp; &nbsp; &nbsp; "Amount other than USD", RMT_CPR[Amount other than USD],&nbsp; &nbsp; &nbsp; &nbsp; "Seg profit 2", RMT_CPR[Seg profit 2],&nbsp; &nbsp; &nbsp; &nbsp; "Real time profit-2", RMT_CPR[Real time profit-2],&nbsp; &nbsp; &nbsp; &nbsp; "Segment Profit (AED)", RMT_CPR[Segment Profit(AED)],&nbsp; &nbsp; &nbsp; &nbsp; "Profit w.r.t real time rate (AED)", RMT_CPR[Profit w.r.t real time rate(AED)],&nbsp; &nbsp; &nbsp; &nbsp; "Difference", RMT_CPR[Difference],&nbsp; &nbsp; &nbsp; &nbsp; "GL Segment", RMT_CPR[GL Segment],&nbsp; &nbsp; &nbsp; &nbsp; "GL Subsegment", RMT_CPR[GL Subsegment],&nbsp; &nbsp; &nbsp; &nbsp; "Sol ID", RMT_CPR[Sol ID],&nbsp; &nbsp; &nbsp; &nbsp; "SOL Desc", RMT_CPR[SOL Desc],&nbsp; &nbsp; &nbsp; &nbsp; "RM Name", RMT_CPR[RM Name],&nbsp; &nbsp; &nbsp; &nbsp; "DELIVERY_CHANNEL_ID", RMT_CPR[DELIVERY_CHANNEL_ID],&nbsp; &nbsp; &nbsp; &nbsp; "Source", "RMT_CPR"&nbsp; &nbsp; ))

rupak_bi · Accepted Answer

hi&nbsp;Smitesh&nbsp;the error you are getting as you are trying to get a table out put in a measure. If you are trying to create a calculated table, then go to the modelling table and select table and then put the DAX to get a union table (hope your DAX is correct). Measure returns only a scaler value and will not work here.

Forum Discussion

Related content

Semantic Model

Healthcare Semantic Model

Semantic Models

Does getDefinition support DirectLake semantic models?

One Semantic model VS Multiple Semantic Models