Forum Discussion
proavinash
Helper I
Helper IThe expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.
please suggest a solution.
Hi proavinash,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The UNION function returns a table as a result, so rather than creating a measure, try creating a calculated table.
Please refer the below Document:
UNION function (DAX) - DAX | Microsoft LearnIf this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
v-saisrao-msft
Community Support
Community SupportHi proavinash,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.