Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Custom ranking (preassigned values)

  Hi Power BI Guru's, I am not a programmer & new to Pwer BI. I seek your help in a custom solution to ranking my data under "Matrix" visualization which I am building for Top 50/100 or 300 custom...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi Anonymous

     

    If you are looking for a MEASURE, you can use this formula

     

    RANK_Measure =
IF (
    SELECTEDVALUE ( TableName[Customer] ) = "Multiple Customers",
    301,
    RANKX (
        FILTER (
            ALL ( TableName ),
            TableName[Financial Year] = SELECTEDVALUE ( TableName[Financial Year] )
                && TableName[Customer] <> "Multiple Customers"
        ),
        CALCULATE ( SELECTEDVALUE ( TableName[Values USD] ) )
    )
)
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

In your expected result, there are some blank row, why they are blank, you only want to display the rank number which is less than 4 in your sample table?

Best Regards,
Angelia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-huizhn-msft , Yes, Rank is required for those blank cells . I kept it blank in the "expected result" field but the adjacent field named "condition" states " as per formula based on field "Financial Year" & sum of "Values USD" ".

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    Ok, got it. Please try the solution Zubair_Muhammad posted, please mark the right reply as answer if your issue has been resolved, and respond to us if you still have other problems.

    Best Regards,
    Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi v-huizhn-msft, yes I got to check that offered solution given by Zubair_MuhammadZubair Mohammad. I thought if in case you want to contribute from your side in a different way :-)

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        8 years ago

        Hi Anonymous,

        Have you tried the solution Zubair_Muhammad posted? Have you resolved your issue? If you have, welcome to share your solution or mark the right reply as answer. More people will benefit from here.

        Best Regards,
        Angelia