Forum Discussion

ManishaDeval_05's avatar
ManishaDeval_05
Regular Visitor
1 year ago

Trend Ranking for Measure

I have created one measure and add them on the basis of rank function,i want that all down arrow will come first,@ down arroe and one flat will come second and for SINC up arrow is bad ,for MTTR and ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ManishaDeval_05 ,

Need few more clarifications

App1,app2 and app3 there 3 came from diff table or single? What condition did u applied for Up and down arrow?

 

Regards,

Surya.

  • ManishaDeval_05's avatar
    ManishaDeval_05
    Regular Visitor
    1 year ago

    These three are from same table and condition i have applies is if the SINCS goes up it will show up arrow and if MTTR goes down it will show down error.

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

      Hi ManishaDeval_05,

       

      Based on your requirements, all red down arrows should come first and the combination of red down arrows and green up arrows should come second.

       

      For this here is the DAX measure:

      SortRank =

      VAR SINC_Value = SELECTEDVALUE(Table[SINC])

      VAR MTTR_Value = SELECTEDVALUE(Table[MTTR])

      VAR MTRS_Value = SELECTEDVALUE(Table[MTRS])

       

      RETURN

      SWITCH(

          TRUE(),

          SINC_Value = "↓" && MTTR_Value = "↓" && MTRS_Value = "↓", 1,

          (SINC_Value = "↓" && MTTR_Value = "↑") || (SINC_Value = "↓" && MTRS_Value = "↑") ||

          (SINC_Value = "↑" && MTTR_Value = "↓") || (SINC_Value = "↑" && MTRS_Value = "↓"), 2,

          3

      )

       

      Add this measure to the table visual and sort your table by this measure in ascending order

       

      If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

       

      Thanks and regards,

      Anjan Kumar Chippa

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

        Hi ManishaDeval_05,

         

        As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked.
        If my response addressed, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

         

        Thanks and regards,

        Anjan Kumar Chippa