Forum Discussion
DataNinja777
Super User
Super UserVariance commentary using contanatenteX sorting large to small balance commentaries
Hi Power BI Community,
I am trying to automate my variance analysis commentary, and I'd greatly appreciate it if you could let me know how I can rank the variance comments by the measure [Stock value variance] by the Material code. I think it will be using RankX or something similar to that, but I cannot think of quickly how to incorporate RankX in the below code.
Thank you for your help!
1 Reply
swikritee_pResolver II
DataNinja777 , Check if below measure can help
Measure = Rank(dense, allselected('material Master'[Material code]), orderby( [Stock value variance]))
Assumed that [Stock value variance] is a measure
https://learn.microsoft.com/en-us/dax/rank-function-dax