Forum Discussion

stevedata's avatar
stevedata
Frequent Visitor
1 year ago
Solved

Issuer sorting column created by union

I created a table using union and created a sort order

TotalRegionsorder = UNION(DISTINCT(Main[Region]),{"Global"})
 
RegionGlobalSortorder
US1
ZA2
Global3
 
In a matrix table first row is RegionGlobal and i want to sort using my sort order but it doesnt work,
It also doesnt work when i have RegionGlobal as a legend in a clusterd column chart and i try to sort by RegionGlobal
 
In my matrix chart when i replace RegionGlobal with Sortorder, only the first 2 rows apper in the table and Global dissappers
When i try and sort the RegionGlobal column by the sortider column i get a circular dfependancy error
A circular depoendancy was detected: Totalregionsorder[RegionGlobal], Totalregionsorder[Regionorder],Totalregionsorder[RegionGlobal].
 
 
Can anyone help? 
 
 
Need Help
  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    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.



     

  • v-aatheeque's avatar
    v-aatheeque
    1 year ago

    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!

7 Replies

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi stevedata ,

      We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

      If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
      If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

      Thank you!

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        1 year ago

        Hi stevedata ,

        If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.

        We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.