I haven't seen it on any UA-cam 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. ❤️
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😘😘
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 ... :)
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 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 😇
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?
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.
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
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
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 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
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
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.
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.
Cann you explain the detail in the email analyticswithnags@gmail.com. Also share the pbix file if it is not confidential we will have a look and reply it you
@@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
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
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
RANK = RANKX ( CROSSJOIN ( ALLSELECTED ( Data[Product name] ), ALLSELECTED ( Data[Product Category] ) ), Data[Totalsales], , DESC ) FOR ME ITS WORKING ONLY WHEN I USE THIS FORMULA
I haven't seen it on any UA-cam 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. ❤️
Thanks for your words.
Keep learning. Share this channel with friends and colleagues
Thank you for your simple explanation with real life scenario.
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
Thanks keep learning share this channel with friends and colleagues and talk about this channel in LinkedIn
Real Lab experience, Thank you very much for the videos
Thanks for watching!
Really superb. Clear explanation 🎉🎉
thanks , keep learning
semma semma,, awesome explanation . Thanks bro
Thanks keep learning share this channel with friends and colleagues and shout out about this channel in LinkedIn
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😘😘
Thanks you , Keep Learning . Best Wishes.
Amazing!!!!!.......Best Regards from Mexico.
Thank you Keep Learning
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 ... :)
Thanks keep learning
great explanation sir, thank u
You are welcome
Hi, how to get dataset that your using in Naga Garments scenario.
Check the description of the video
Thanks
Keep learning
Thanku sir
Thanks keep learning share this channel with friends and colleagues
Hi Nags, Can cross join happen between 2 different tables? if so, what will be the syntax? Thanks
Watch cross join video in Dax playlist
Nice explanation with multiple functions.. Thank u bro
Glad you liked it
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
Sion will make video on this
Can we use total count also instead of sum?
Yes
@@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 😇
I am only able to select either country or query type using TopN filter.
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?
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.
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
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
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
Try asc or desc option shown in the DAX
@@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
@@anushap5411 why have u used calculate function there ? What is it calculating ??
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
Check the video on how to test your power bi reports
It will shows only 32 videos of dax. I need remain 18 videos of dax please.
Don't Repeat same comments which was answered already.
Those remaining videos are planned not yet ready. I hope you understand now.
apply filter from month also and show , especially mon5h
Not sure what is your question
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
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.
@@AnalyticswithNags Thank you so much for input...I will try it..
@@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...
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.
Cann you explain the detail in the email analyticswithnags@gmail.com. Also share the pbix file if it is not confidential we will have a look and reply it you
Hi. Basically All function removes all the filters. Why do you use All here?
Watch again
@@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
It is based on the function you use. If the function requires column as an argument or table as an argument
can you show rankx dax function example where rank is applied on Percentage value, I am rank on Profit percentage
I hope there is no difference while using percentages, you can apply same logic
Too n and bottom and can find by filter then why we use rank
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
How to give ranking to Quarters
In case of quester use that column in ranks functions
how to fix Total for Rank measure?
can you explain a bit clear on the requirement ?
what is different between topn and rank please make video on topic
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
@@AnalyticswithNags thanks sir ,give me ans
Sir explain each functions with more examples plz
Sure I will
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?
Use that rank measure in the visual filter and basic filter and choose 2
How to find last 6 months sales
ua-cam.com/video/wS2Hw9CPJeY/v-deo.html watch this it is explained in this Video
RANK =
RANKX (
CROSSJOIN (
ALLSELECTED ( Data[Product name] ),
ALLSELECTED ( Data[Product Category] )
),
Data[Totalsales],
,
DESC
)
FOR ME ITS WORKING ONLY WHEN I USE THIS FORMULA
Then go for it
RANKX is not workinng even after using ALL function
Explore the similar problems here, learn.microsoft.com/en-us/answers/