Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Ranking Issues

1.Hi Folks, I am using  source is tabular cube. How we build the cube we are calling all facts in view(Main FactTable) and connect with Dimenssions. Now my view producing 800000(8 lakhs) records so w...
Need Help
Tips and Tricks
nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

Anonymous 

 

In your Excel file, I could see only one table.

Based on that, I have created the below measures.

PaidAmount = SUM(MyTable[Paid])
rankValue = RANKX(ALL(MyTable[PROVIDER_ID]),[PaidAmount],,ASC,Dense)



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

i did same thing it's working fine but i add other dimensson columns ranking is not working and it's displaying duplicate ranks and top 50 records also not working.

  • nandukrishnavs's avatar
    nandukrishnavs
    Community Champion
    6 years ago

    Anonymous 

    Can you share other dimensions also in the excel file? 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Any solution for this, Please help me to get resolve this issue.

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    Any progress?

    If you still have any issue, could you please share some sample data as screenshots?

    And remember removing any sensitive data

     

    Best Regards,

    Giotto