Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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,
Solved! Go to Solution.
https://www.dropbox.com/s/cmg4gbsdy54gi10/RankX_file.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
https://www.dropbox.com/s/cmg4gbsdy54gi10/RankX_file.pbix?dl=0
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
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
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.
User | Count |
---|---|
77 | |
76 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |