Issuer sorting column created by union

Hi stevedata ,

Based on the above error , need to remove [RegionMEASURE0]) measure from the calculated column , because its wont supported.
Use this DAX : 

RegionOrder2 =
SWITCH(
    TRUE(),
    TotalRegionsorder[RegionGlobal] = "Global", 1,
    TotalRegionsorder[RegionGlobal] = "US", 2,
    TotalRegionsorder[RegionGlobal] = "ZA", 3,
    999  -- default fallback numeric value
)

expected output :

Hope this helps !

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Thanks for using Microsoft Fabric Community Forum.

Hi stevedata ,

Have you resolved the issue? If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!