Rank your values using RANKX DAX Function in Power BI // Beginners Guide to Power BI in 2021

[@ranimaharaj-sharma4332]

Excellent video on RANKX.. Very easy to follow. Love the difference between ALLand ALLSELECTED.. Thanks for great video.

[@dinokid-u1i]

man man man ... so much respect i wacht so much videos about power bi but i just leren from you man you fox in details its amzing . really thank u

[@SolutionsAbroad]

Thanks for watching!

[@ashokkumarpadmanabhan6483]

Excellent Video !!! clearly explains RankX Function.... You are rocking..... Keep sharing videos Appreciated your effort !!!

[@Howtoexcelatexcel]

Excellent tutorial, clear and concise. Thank you. Thumbs Up

[@SolutionsAbroad]

Thanks for watching, appreciate that!

[@venkatesh5420]

wonderful video on Rankx thank you so much for giving such good content,

[@mustafamd8024]

Very useful, thanks a lot ❤

[@SolutionsAbroad]

You're welcome 😊

[@qaisurrehman]

very useful, thank you Fernan!

[@emilyamalkin4367]

Excellent tutorial with perfect explanation, backed up by visual representation. Thank you!!!

[@petercompton538]

Thanks very much. How do you get rid of the rank for the Total (which is meaningless)?

[@akashragi2347]

If I wanted to skip the ranking for blank category names , how can I do that ?

[@OmarovM]

hi sir.I have a question at 12:08 3 dublicated but i want 3,4,5 like row number.Thanks in advance.

[@PhillipLearnTeach]

How do you make a measure or a calculated column that consist of a measure and certain values from a columns from either same table of separate table?

[@SolutionsAbroad]

Hi Phillip, measures and calc columns are identical but not similar. Here's a video explaining how they're different: kzbin.info/www/bejne/pKSXh5Wmh7B0fNU Measures can reference columns or measures anywhere in the dataset Calculated columns is data within a table, if you want to reference columns from other tables, there has to be a relationship that connects those tables together, here's a video on relationships if it helps: kzbin.info/www/bejne/hYDWXomNm5dje5o

[@moshearama6612]

Hello and thanks for the video How do I overcome the fact that I have two lines with the same RANK?

[@TomášTkáčik-h4e]

Hi, is it possible to somehow solve problem when I need to use in ALLSELECTED function columns which are from multiple table? Thanks

[@RawShooters]

Hi if there are two values similar then how it will show the result please give details

[@SHIYUNQU]

very clear !

[@srikanthjella1458]

Excellent video sir but if we have any duplicate values in total sales then ranks will give dupliscte/same numbers right how we will overcome that sir

[@pavani008]

How to create a measure to calculate sum of sales of rank 10? I tried but when I tried to add that in to a table it shows grand total instead of sum of sales for rank10

[@DivyaGupta-zq3ne]

What is i want to rank them unique for ties. can u help on that

[@EngineeredFoodies]

Hi i am facing an issue in displaying a "0" in card visual by not selecting any value in the slicer/dropdown

[@SolutionsAbroad]

Hi, that's because there's no context on our card, that's the only reason i could think of. Have you tried putting it on a table to see your results?

[@EngineeredFoodies]

@@SolutionsAbroad Hi I found the solution by using "if" with "Hasonevalue". Now if there is no selection from the slicer for displaying the rank of a team, it displays zero. Thank you for your support.

[@EngineeredFoodies]

50 Years of International Cricket kzbin.info/www/bejne/ooKxgaOebNd7m6M

[@RawShooters]

Suppose in a class room two are more students secure same marks how will it be?

[@misterctoon11]

What if I had a product that had different attributes that I wanted to calculate a sum of ranks? (Ex 1) Or how about can I limit the rank range? (Ex 2) Example 1.) Product most $ sales rank, most ordered rank, least returned rank. Sum them up, the total rank LOWEST the number the best "overall product" Example 2.) I have 100 products but don't want rank 1-100. Maybe I only want to divide up these into groups of 10. Can I limit the "rank" to a range I specified? Thanks!

[@buncarter9774]

Hi Sir, Avid viewer here. I have question: I have two tables with the same data. In report tab I created a table and drag the columns of source data from the table1 and table2. example: table columns composed of table1.projname ,table1.projstatus ,table2.projname,table2.projstatus. I created two slicers , slicer1 will filter table1.projname and slicer2 will filter table2.projname. it's like column based filtering. (sorry for my english:D) Hope for your feedback. Thank you in advance.

[@SolutionsAbroad]

Hi Brent, thanks for watching! From what I understand, you're looking to create a filter that applies on both tables? In that case you need a another table, that relates the two tables together, you can follow this video here: kzbin.info/www/bejne/hYDWXomNm5dje5o

[@buncarter9774]

@@SolutionsAbroad , thanks for the reply, not relationship, it's like column filtering based on unrelated table. Eg. Like comparing task A status from Task B status where table A and table B are the same data..

[@dianamgdata]

Hello! I am having trouble to get the first ranking cells. I get 1 in all the cells :(

[@MotobikerVroon]

Hi, I have created RankX dax formula for operating expense data table in power bi but when I add the rank into column, the ranking starts with 0,1,2,3,.. What is the reason for this and how can i fix this issue.

[@entrenadordesofa]

Add +1 to your RANKX measure

[@krishikasentertainment7697]

After using all function i am getting the same error of same rank as 1 1 1 . What should I do .?

[@naresh3800]

First view