Margin in % in a Matrix table by adding a sorting column

Thanks for the reply from AntrikshSharma , please allow me to provide another insight: 
Hi  M_Chris ,

Power BI default sorting is alphabetical, if your data [KPI] has multiple identical values in a table or there is a circular dependency problem, you may consider creating a new table to customize the sorting.

Create calculated table:

SUMMARIZE(
    'Table',[KPI],"Rank",SUMX('Table',[Value]))

Select [KPI] – Column tools – Sort by  column – [Rank].

Joins the relationship between two tables.

Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.