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,

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi v-huizhn-msft, the solution worked by Mr. Zubair for summarised recrods in a table. I am now looking for a cmore lengthy data with multiple values in the same financial year.

 

I will post the PBX file & tag you as well in the question.

Thanks,

Chandan