The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

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 Learn

If 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.