Forum Discussion
Solved
Union between 2 semantic models
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." ...
hi Smitesh
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.
Rupak_bi
Super User
Super Userhi Smitesh
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.