Rankx with multiple filter problem

[Ramachandran]

Hi,

I'm facing problem with RANKX() field. My source data is look like,

My code - RANKX(
FILTER(ALL('Country Detail'[Country]),
NOT ISBLANK([Debit]))
, [Credit])

The rank it is showing 1 for each row.

I need output is like 

The Rank column should be calculated based on Credit field and not allow any blank values like country, state and debit columns.
some one assist me how do I handle it.

thanks,

[Jihwan_Kim · Accepted solution]

https://www.dropbox.com/s/cmg4gbsdy54gi10/RankX_file.pbix?dl=0 

[Kumail]

Hello @Jihwan_Kim 

Just saw your .pbix file. 

In RankX, the row context is on the column given with the table submission, or when the table has just a single column. 

In the current file, the whole table is provided in the RankX function and yet the ranking is done by just State and not by country in the visualization is just a bit confusing. 

This is really confusing the things. Any help would be highly appreciated!!

Thanks,

Kumail Raza

[Kumail]

Hello @Ramachandran 

If you could send sample .pbix that demonstrate what you are looking to get. It would really help providing you a quick solution.

Regards

Kumail Raza
Kumail Raza

[Ramachandran]

I shared pbix file location is below

https://drive.google.com/file/d/1v_9WpcrmR_7YgOVUORlyTpyB7ki8_8wo/view?usp=sharing

Please check and let me know.