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
Icon for Community Champion rankCommunity Champion
6 years ago

Anonymous 

 

I don't have access

  • nandukrishnavs's avatar
    nandukrishnavs
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

     

    Is this what you are looking for?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      yes based on paid amount want to display TOp 50 ranks by using dax not an index column or genrate series function becase my sorece is tabluar cube and seen image you are taking column from only one table so my table having dfferent table columns. Please take columns from different table apply top 50 ranks

      State licence came from Table A(Procedure id)

      Provider Legacy Number, Provider name came from Table B(Provider id, Name)

      Paid Amount, Total claim services, Unique patients,# of service  Came from Table3 Fact(This all are sum)

      • nandukrishnavs's avatar
        nandukrishnavs
        Icon for Community Champion rankCommunity 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         🙂