Power BI DAX Tutorial (15/50) - What is RANKX

[@susantadas8213]

I haven't seen it on any KZbin channel to explain in such a simpliest way. Medicine for all kind of problem is available on your channel. Great going keep it up bro. ❤️

[@AnalyticswithNags]

Thanks for your words. Keep learning. Share this channel with friends and colleagues

[@Aadya.Boutique642]

Too n and bottom and can find by filter then why we use rank

[@AnalyticswithNags]

It is used in other calculations as a intermediate results. Also you want to find which item in 10th position or nth position Rank is the function we should use

[@govardann6831]

It will shows only 32 videos of dax. I need remain 18 videos of dax please.

[@AnalyticswithNags]

Don't Repeat same comments which was answered already. Those remaining videos are planned not yet ready. I hope you understand now.

[@DawoodChoudry-r3j]

Hey, you explained well all dax functions but I have a question When we do a crossjoin between two columns then there will be possible combinations of rows where we don’t have a total sales value? Is it good approach?

[@coolcalm582]

sir why crossjoin has been used here...rest all things i was able to grasp but didnt get why cross join function is used. can u please reply here making me understand please it will be very helpful.

[@devender476]

RANK = RANKX ( CROSSJOIN ( ALLSELECTED ( Data[Product name] ), ALLSELECTED ( Data[Product Category] ) ), Data[Totalsales], , DESC ) FOR ME ITS WORKING ONLY WHEN I USE THIS FORMULA

[@AnalyticswithNags]

Then go for it

[@sudhavani6279]

hai sir, i hope i will get a repl from your end, what is the number indicates below the rank column,,, for total sales "7378400" it is sum of total sales under the column, but under rank column the number "1" indicates what???, pls repl sir

[@AnalyticswithNags]

The measure based on each item it ranked properly since filter context applied. In total no filters applied so total value is ranked as one. Usually ranking you should not show the totals. Ignore that

[@rameshkale2101]

can you show rankx dax function example where rank is applied on Percentage value, I am rank on Profit percentage

[@AnalyticswithNags]

I hope there is no difference while using percentages, you can apply same logic

[@pallavimoon3349]

Sir wld u plz provide exact data which have been used .i m not able to check wether the my ans or dax are correct

[@AnalyticswithNags]

Check the video on how to test your power bi reports

[@sidharthagoswami7353]

Hi Nags, Can cross join happen between 2 different tables? if so, what will be the syntax? Thanks

[@AnalyticswithNags]

Watch cross join video in Dax playlist

[@AnilKumar-fr9jo]

Awesome video, I am a new learner, and the video is very informative and helpful to understand in simple terms the complex DAX formulas. Great work ... :)

[@AnalyticswithNags]

Thanks keep learning

[@collinsegbo1350]

This is great. But can you create a video with Ranking based on multiple measures. For example, the major column is Product Category while the measures are Total Sales and Profit Margin. Both Measures will have their rankings on the same table

[@AnalyticswithNags]

Sion will make video on this

[@anushap5411]

Hi Nags, I’m trying to use a rank on a column which has negative values. Until my Value is positive, it’s working fine. ( 1 2 3) But if the value is negative rank is jumping to (22 23 24). Can you pls help me

[@AnalyticswithNags]

Try asc or desc option shown in the DAX

[@anushap5411]

@@AnalyticswithNags rankx(ALL(VW_NAV[Fund_Name]),CALCULATE('VW_NAV'[Return_PTP]),,DESC,Dense) Hello. By implementing the above DAX , my rank is skipping by 1 when the values become negative ( eg - 1 2 4 5 6) . Can you pls help me

[@rajesh4951]

Hi, how to get dataset that your using in Naga Garments scenario.

[@AnalyticswithNags]

Check the description of the video

[@podamaire]

apply filter from month also and show , especially mon5h

[@AnalyticswithNags]

Not sure what is your question

[@vrmotovlog4333]

Real Lab experience, Thank you very much for the videos

[@AnalyticswithNags]

Thanks for watching!

[@shrutisharma1434]

This video is one of the best videos, I have watched on this topic . Very well explained and that too in a very easy way . Thank you so much

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues and talk about this channel in LinkedIn

[@antipghosh]

Thank you so much for the videos.. I have been trying to learn Power BI through your channel... Sir, I have a doubt... How to do summation in a list wherein I need to selectively exclude first 6 Non-zeroes & do sunmation for the rest... This data is available daywise thus for each day..first 6 instances of non-zeroes to be excluded & sum should containg only the remaining for that particular day.... Kindly guide

[@AnalyticswithNags]

Create a calculated column in power query or DAX that removes first 6 zeros. (Watch the videos in tips and tricks playlist) Then use this calculate column in sum function.

[@antipghosh]

@@AnalyticswithNags Thank you so much for input...I will try it..

[@antipghosh]

@@AnalyticswithNags sir, In the list there are a mix of zeroes & non-zeroes numbers... I need to sum up only from 7th Non-zero numbers...

[@sunilkumar3112]

RANKX is not workinng even after using ALL function

[@AnalyticswithNags]

Explore the similar problems here, learn.microsoft.com/en-us/answers/

[@varun1023]

Really superb. Clear explanation 🎉🎉

[@AnalyticswithNags]

thanks , keep learning

[@salidandigopi4358]

How to give ranking to Quarters

[@AnalyticswithNags]

In case of quester use that column in ranks functions

[@MertinMystik]

Hi I am doing a report on sales, where I want the pictures of the products shown in their respective ranks. What I want to show is a top ten with ten single image visuals (not in a table visual) that shows 1, 2, etc. respectively. I tried combining my picture table into my sales table and do a cross join like you, and then use rank as a filter for each visual, but that gives massive performance issues. ~60 seconds to load each ranked product picture for each time I change a page filter like month or product group. I tried doing rankx with the picture still in its own table, but that messed up the rank. Do you have any tips? I've searched far and wide, and no one address how to use rankx function with values from more than one table.

[@AnalyticswithNags]

Cann you explain the detail in the email [e-mail]. Also share the pbix file if it is not confidential we will have a look and reply it you

[@vinodkumarjounepalli8049]

great explanation sir, thank u

[@AnalyticswithNags]

You are welcome

[@abdulqadeerkamangar6279]

Can we use total count also instead of sum?

[@AnalyticswithNags]

Yes

[@abdulqadeerkamangar6279]

@@AnalyticswithNags Pls share formula Sir... I have to prepare stacked bar chart... Where I need top 5 countries and top 5 query types based on case reference count... Country and queries in separate column... Pls help Nag Sir... Thanks a bunch for quick response. Appreciated 😇

[@abdulqadeerkamangar6279]

I am only able to select either country or query type using TopN filter.

[@bharathkumarthatikonda4982]

I am learning all types of DAX Expressions from your channel. I think you are explained it deeply and practically. Most Useful and knowledge sharing Channel😘😘

[@AnalyticswithNags]

Thanks you , Keep Learning . Best Wishes.

[@karthicr6568]

semma semma,, awesome explanation . Thanks bro

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues and shout out about this channel in LinkedIn

[@venkatareddykummitha5863]

Thanks

[@AnalyticswithNags]

Keep learning

[@sravankumar1767]

Nice explanation with multiple functions.. Thank u bro

[@AnalyticswithNags]

Glad you liked it

[@piyushpathak7311]

Sir explain each functions with more examples plz

[@AnalyticswithNags]

Sure I will

[@nittinvashisht5697]

how to fix Total for Rank measure?

[@AnalyticswithNags]

can you explain a bit clear on the requirement ?

[@akshayachandrasekar8285]

Hi. Basically All function removes all the filters. Why do you use All here?

[@AnalyticswithNags]

Watch again

[@akshayachandrasekar8285]

@@AnalyticswithNags ok. I have another doubt can you please say when to use tablename as argument and when to use column name as arguments. I'm confused

[@AnalyticswithNags]

It is based on the function you use. If the function requires column as an argument or table as an argument

[@raviranjansingh5527]

what is different between topn and rank please make video on topic

[@AnalyticswithNags]

Top n only focus on highest values. Whereas the RanKx can be used for highest and lowest value. Secondly, If you want to find who has got the n th rank you can filter using RanKx. E.g Who has got 5th rank

[@raviranjansingh5527]

@@AnalyticswithNags thanks sir ,give me ans

[@cesarsaldana3429]

Amazing!!!!!.......Best Regards from Mexico.

[@AnalyticswithNags]

Thank you Keep Learning

[@adventuresofvyomandkeshav3036]

Thanku sir

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@devinenipradeep7771]

How to find last 6 months sales

[@AnalyticswithNags]

kzbin.info/www/bejne/rYSVeapveLV9m7s watch this it is explained in this Video

[@pushpakjadhav6540]

I have 1 doubt - In this video, you have ranked categories as 1, 2 , 3 etc. If I want to find out 2nd Rank value in Card visual how can we achieve it?

[@AnalyticswithNags]

Use that rank measure in the visual filter and basic filter and choose 2