Ranking Issues

[Anonymous]

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 while connecting power bi and using some columns in a table and apply the ranking functionalty(1,20,000 records in one table) but it's not producing correct ranks. Is it possible to apply ranks for huge volume of data. When am applyingrank is asc it's always giving as 1 1 1 1 1 11 1 1 1 2 2 2 2 2 2 2 2 2l .ike this

2. even when i apply TOP 50 records on the volume of of data like 1,20,000 it's not filtering 50records.

Can you please clarify is it possible in Power bi to apply ranks on volume of data.

[v-gizhi-msft]

Hi,

Here is rank created by measure and column:

Rank(Measure) = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Value])),,ASC,Dense)

Rank(Measure) = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Value])),,ASC,Dense)

The result shows:

See my attached pbix file.

Best Regards,

Giotto

[nandukrishnavs]

@Anonymous 

It is possible. Refer to this link.

https://www.sqlbi.com/articles/use-of-rankx-in-power-bi-measures/

If you can share the sample data, then we can try that.

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

[Anonymous]

 Hi Please find the below sample data.

State licence came from Table A

Provider Legacy Number, Provider name came from Table B

Paid Amount, Total claim services, Unique patients,# of service  Came from Table3 Fact(This all are sum), Now i want to display Top 50 records based on paid amount. Please let me know if you need any information.

[nandukrishnavs]

@Anonymous 

Can you share the data in a table format (Not image)? Or in an excel file? You can mask your confidential data and share few rows and expected output.

[Anonymous]

Hi Please find the sample data, Rankx should be created as calucalted measure not index column becacuse my source is tabular model so i can't create index column or Generateseries function.

https://drive.google.com/drive/u/0/folders/1PCfqXc90S4qFg374-GxIo-5uh2YoF8NC 

[nandukrishnavs]

@Anonymous 

I don't have access

[Anonymous]

https://drive.google.com/drive/folders/1PCfqXc90S4qFg374-GxIo-5uh2YoF8NC?usp=sharing

Please check now, i have given access to public.

[nandukrishnavs]

@Anonymous 

Is this what you are looking for?

[Anonymous]

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]

@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]

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]

@Anonymous 

Can you share other dimensions also in the excel file? 

[Anonymous]

https://drive.google.com/drive/folders/1PCfqXc90S4qFg374-GxIo-5uh2YoF8NC?usp=sharing

Please find the multiple tables sample data.

[Anonymous]

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

[v-gizhi-msft]

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