RankXing concatenatex variance commentary by value

[DataNinja777]

Hi Power BI commnity,

I'd greatly appreciate it if anyone could let me know how I can tweak the ConcatenateX dax measure below so that the variance commentary is ranked by value.  

Thank you for your help.

[amitchandak · Accepted solution]

@DataNinja777 , You can use order by expression in concatenatex

https://learn.microsoft.com/en-us/dax/concatenatex-function-dax

[DataNinja777]

Thanks @amitchandak !

It worked perfectly.