Trend Ranking for Measure

[ManishaDeval_05]

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 mtrs up arrow is good

App1
SINC	↓
MTTR	↑
MTRS	↓
App2
SINC	↓
MTTR	↓
MTRS	↓
App3
SINC	↓
MTTR	↔
MTRS	↓

[v-achippa]

Hi @ManishaDeval_05,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @Karsurya12_03 for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @ManishaDeval_05,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[Karsurya12_03]

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]

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]

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]

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

[Karsurya12_03]

@ManishaDeval_05 ,

What is exact requirements? do you mean flat is MTTR<-> ? what about up arrow didn't mention anything like as whether do we consider  it will comes in 3 rd or ignore?

Regards,

Surya

[ManishaDeval_05]

MTTR & MTRS up arrow and SINC down arrow will come first, according to the screenshot all red will come first and the two red one green

[Karsurya12_03]

Hi @ManishaDeval_05 ,

                                      For my understanding will be,all down arrow will show in first and it will be redcolor and combination of up arrow and down arrow will comes second if green means up arrow.Am i right?

Regards,

SK.

[ManishaDeval_05]

Yes Right