Out of hundreds of thousands of videos that claim to teach DAX, there are only a handful of videos that actually emphasize on DAX concepts. This video is one of them.
This shouldn’t be used as a normal video … it must be used as a handbook whenever anyone wants to write a DAX equation Really very great one .. I love it 🤝🙏🏻👍
I have seen this video multiple times, bookmarked it on my browser. I keep referring back to this video from time to time to brush up my DAX fundamentals. Thanks for uploading such a great content.😀
Really great video as always. I love how you show the incorrect steps people commonly make along the way and then show how to resolve. Thank you for your hard work.
Excellent content so far and I'm looking forward to viewing more. What I like about what you've done here is that you don't assume a lot and you don't go down the rabbit hole. For example, you mention variables and constants but you don't spend much time on defining those. You say just enough to make the point and the continue on with variable usage, which was the topic at hand. I like that. You show your work without a lot of extra fluff so that it's easy to understand and you don't assume pre-existing knowledge. Even better, the presentation is fantastic.
A "must" for anybody looking to use DAX. It makes clear what the "context" concept means and what's the rationale to use measure or calculated columns , not just choosing one or another because it's the right way but to understand the reason for that.
From the title I thought this was a beginners guide, but definitely not. Will come back to this video later when I actually know more about DAX and know what Bas is even talking about haha
Great stuff, Bas! You have explained the concept succinctly and precisely. I did have trouble to explain the context transition accurately to my colleagues. Thanks for the tip
In DAX world, table filters are not healthy when it comes to performance (report, code, capacity usage etc.). I have seen many UA-camrs making this mistake, and people learn those methods without knowing the impact (Example: dimCustomer in YT Video may have x number of records where as in reality it might be (x+n) rows with hundreds of columns. Was happy to see REMOVEFILTERS(dimCustomer[Customer Name]) at last somewhere instead of ALL(dimCustomer). Thank you
I love the video. Very accessible for beginners. Feedback: I would have done the when to use measures first (before discussing filter context in measures).
This video should be used by MICROSOFT as reference .....for me dax was like a rocket science ....but after watching this video its so easy....thank u so much
Your explanations are awesome. Pls help me on the following. How can I COUNTIF Whinin a measure ? Example. Measure 1 = calculate the average weekly sales per Salesman. Measure 2 = Count the Saleman below 70% of average sales (Measure 1) on a particular day, for each branch
Thank You ..yours explanation is great... Can you Please make a video on Power BI Cohort Analysis,finding lost customer, Return customers.... Always find them challenging to evaluate....
thanks for this video i have a query on while calculating average sales it has been mentioned there is filter context which was not there before . can anyone clarify where is the filter context came on customer name ?
In the calculated columns that you used to classify the customers what if you had to have a slicer by product and the class of client had to change depending what product you select? Everything I read says that calculated columns are static and calculated when the table is built but you can't use a measure has the first columns of a matrix so I can't think of a way to resolve this.
This video is really amazing. Could you help me with the below situation. I have a sales table and sales return table which records daily sales and return transaction where both table connected to a date dimention table. I need to create a measure to find difference of sales and return till to the day level. Also need to calculate MTD and YTD of this measure.
IMHO understanding row context, how filters flow from dimension tables to the fact table through relationships to create subsets how the CALCULATE function creates context transition are key aspects when learning DAX.
Another amazing video by the guy that's better than Netflix! Thanks again Bas! I have a question though: Is there a way to filter by using only part of the value and not the whole word? For example instead of finding all Sales for which [Product Category] ="Hair", can we find all Sales for every [Product Category] that contains let's say the letters "*AI*" somewhere in the [Product Category] field?
great video to get started, I wish I found this one earlier in my career. by the way, you missed the allselected() function to calculate sub totals that everyone else talks about all the time lol.
Great video! quick question, How can we filter our visual by the value of the measure we created, let say we want to see specific range of Cost% to sales without creating calculated colomn?
Now im curious why you wrote a variable at the end instead of writing another measure that used previously- created measures, like ‘total sales’ and ‘total sales ALL’. That is how I have been doing it 😮.
Could you make a video showing how to create a stock price variation line chart that always start on 100% doesn’t matter the start date you select in the slicer?
Great stuff! But don't you think that the average sales by the customer should not be identical? They bought on different occasions at different times so.... What that expression does is merely dividing the total sales by the number of customers in the customer table I reckon instead of ALLcustomer as the first argument of AverageX we should use 'fctSales' instead.
Hi Bas! Thanks a lot for this video and all of them, i'm new at dax and your channel is being really useful. I'm having trouble understanding context transition. I've tried appying the calculate(sum()) formula, but it doesn't respect the calendar table filter. If i use a meassure it works correctly, but i think i need a calculated column with the amount, since the goal is to label the customer according to 3 categories for the amount of income of each one. Could you give a hint? thanks in advance. Kind regards.
Hi, is there a way to get a specific date values thru DAX e.g. getting the sales every 1st of the month then comparing it with current sales value. I tried using CALCULATE and FILTER but the 1st day sales only shows on the total rows but doesn’t show up on each rows. It will only show the per row values if the selected report date is 1st of the month. Hope you can cover it in your future video
how much SQL knowledge is required for Power BI developers with 2 to 3 years of experience, and in an organization, do Power BI developers have to handle SQL tasks themselves or is there a dedicated SQL team for that?
Hi I have a power bi question. My rows are different places and my columns are different toys sold at those places. I want to measure a specific toy and check what they did in Q1 and Q3 in year 2021 and next to it before the next toy I want to see Q1 and Q3 year 2022. However when i do that the 2022 only starts after all the quarters of the previous year is filled how do I put both years together as a measure to see If I am profitable?
Hello Bas, thanks for your videos, I learned so much. Can you share also the name of the cream or hair product you use in your hair? Its really nice. 😊
Great video! In the last example, would it not be better to remove all filters on the dimCustomer table and not just on Customer Name that may not even be unique? There may still be a filter on customer no or customer id or something.
if you would add a further breakdown to the visual (for example customer segment) it would lead to a different result (% of overall total vs subtotal) .. just depends on what you are looking for -> work with the minimum number of columns to reach your goal
Note to my past self: 1) If you want to use the result of a calculation as a filter, then your calculation must be performed within a calculated column (as shown in this video). 2) If you want your result to itself be sensitive to the use of filters, then your calculation must be performed within a measure.
Please make a video about APIs! I have too much data without PBI connections (as Google sheet, we use Zoho mail). And it has been a painful journey to work like this lmao
I still cannot get my head around this. So I started tampering with the same expression and when I applied the same code but without the calculate the same numbers were returned for customers regardless of whether I used Allcustomers or just Customers. It seems that the row context of fctsales[sales], which is a calculated column, overrides the preceding row context on customer, that is Allcustomer behaves the same as customer alone. If you could please clarify this would appreciate it.
@@HowtoPowerBI I'm trying to make up for it by sharing with my colleagues now as well. Our whole group had just started using Power BI in a big way, and even with a strong excel background, I'm finding DAX challenging.
Out of hundreds of thousands of videos that claim to teach DAX, there are only a handful of videos that actually emphasize on DAX concepts. This video is one of them.
The others?
"Correct Context is everything". this is the one video which should help all new comers into the world of Power BI.
that's right - understanding that gets you a looong way with dax. Thanks for watching Rajneesh!
This shouldn’t be used as a normal video … it must be used as a handbook whenever anyone wants to write a DAX equation
Really very great one .. I love it 🤝🙏🏻👍
I have seen this video multiple times, bookmarked it on my browser. I keep referring back to this video from time to time to brush up my DAX fundamentals. Thanks for uploading such a great content.😀
Really great video as always. I love how you show the incorrect steps people commonly make along the way and then show how to resolve. Thank you for your hard work.
The 👏🏼 best 👏🏼 power 👏🏼 bi 👏🏼 guru 👏🏼 ever 👏🏼
thank you so much for the compliment Kenny!
Such a lovely guy who share all of his knowledge on powerbi on UA-cam for free. With all shortcuts, no hold barred. God bless you my brother.
Excellent content so far and I'm looking forward to viewing more. What I like about what you've done here is that you don't assume a lot and you don't go down the rabbit hole. For example, you mention variables and constants but you don't spend much time on defining those. You say just enough to make the point and the continue on with variable usage, which was the topic at hand. I like that. You show your work without a lot of extra fluff so that it's easy to understand and you don't assume pre-existing knowledge. Even better, the presentation is fantastic.
That opening is exactly how I have felt trying to do DAX. I have a programming background and DAX makes me want to pull my hair out sometimes....
Amazing! You have turned a complex topic to simple by breaking it down step by step explanation. Many thanks for sharing your wisdom!
One of the very best Power BI training videos. Superbly explained, professional and charming delivery. THANK YOU!
The core of DAX in 20 minutes…
Thanks Bas for your videos !
The best video I have ever seen to differentiate between Calculated Column vs DAX!!!
A "must" for anybody looking to use DAX. It makes clear what the "context" concept means and what's the rationale to use measure or calculated columns , not just choosing one or another because it's the right way but to understand the reason for that.
Love your narration. Always simple, concise and in a business context. Nice video.
Of all videos out there, this one actually made DAX easy! Thx Bas!
I come back to this video all the time.
Very simple explanation, yet covers the main concepts, easy to understand for everyone - Thank you bro !
Thx for watching :) glad you liked it
The weighted and unweithed way was really illuminating! Thanksss!
From the title I thought this was a beginners guide, but definitely not. Will come back to this video later when I actually know more about DAX and know what Bas is even talking about haha
I need a video on how to create such videos!!
I like the way you zoom the screen to keeping us focused on the important parts
thank you Yassir - there's a lot of free good stuff on video editing with premiere pro - just get started and learn by doing :D
Dude you are the GOD of PowerBI. Discovered your channel day before yesterday and I'm loving it
awesome! Welcome to the channel then :)
I know fir sure you are good .. plz do more on dynamic colorful themes n charts on power pi. Keep it up.. u make learning easy
Another important question! When would you use calculated column vs...doing it in power query ? when would you use one over theo ther?
I need to send an apology message to my boss cos I've calculated a whole lot of rubbish 😂
Ahhahahgood one at least now its over!
"Easier NOT easy" - Nice work Bas, thanks for sharing. 👍👍👊👊
Perfect combination of teaching skills and good looks.
Saluti dall’Italia 😘
Great stuff, Bas! You have explained the concept succinctly and precisely. I did have trouble to explain the context transition accurately to my colleagues. Thanks for the tip
I love your channel and your vibe. Thanks for making a frustrating topic so much easier. Please do more PowerBI vids on Dax and M.
Thx :) will think about this
Super bedankt ! Clearly explained and helps getting on track, removing the fuzz and confusion!
In DAX world, table filters are not healthy when it comes to performance (report, code, capacity usage etc.).
I have seen many UA-camrs making this mistake, and people learn those methods without knowing the impact (Example: dimCustomer in YT Video may have x number of records where as in reality it might be (x+n) rows with hundreds of columns.
Was happy to see REMOVEFILTERS(dimCustomer[Customer Name]) at last somewhere instead of ALL(dimCustomer).
Thank you
Thank you, always enjoy watching your videos! :)
Thank you, Bas, for this very useful information. Also, clear and precise, as always!
i really need this ! thanks for sharing this video ...very helpful and hope you ll share video on data modelling
I love the video. Very accessible for beginners. Feedback: I would have done the when to use measures first (before discussing filter context in measures).
This video should be used by MICROSOFT as reference .....for me dax was like a rocket science ....but after watching this video its so easy....thank u so much
Love your approach.
Your explanations are awesome.
Pls help me on the following.
How can I COUNTIF Whinin a measure ?
Example.
Measure 1 = calculate the average weekly sales per Salesman.
Measure 2 = Count the Saleman below 70% of average sales (Measure 1) on a particular day, for each branch
Thank You ..yours explanation is great...
Can you Please make a video on Power BI Cohort Analysis,finding lost customer, Return customers....
Always find them challenging to evaluate....
thanks for this video
i have a query on while calculating average sales it has been mentioned there is filter context which was not there before . can anyone clarify where is the filter context came on customer name ?
In the calculated columns that you used to classify the customers what if you had to have a slicer by product and the class of client had to change depending what product you select? Everything I read says that calculated columns are static and calculated when the table is built but you can't use a measure has the first columns of a matrix so I can't think of a way to resolve this.
Great thanks from India 🇮🇳 🇮🇳 🇮🇳 namaste
This video is really amazing. Could you help me with the below situation. I have a sales table and sales return table which records daily sales and return transaction where both table connected to a date dimention table. I need to create a measure to find difference of sales and return till to the day level. Also need to calculate MTD and YTD of this measure.
I just stumbled onto your page. I love your style and breakdown of instruction. Good stuff!
thx James for watching!
Probably the best explained video I have seen about DAX, thanks a lot !
Glad to read this Erik!
IMHO understanding row context, how filters flow from dimension tables to the fact table through relationships to create subsets how the CALCULATE function creates context transition are key aspects when learning DAX.
Agree
Awesome!!! I just started using variables watching your video 👍👍
Bruv you need to go a long way in making DAX playlist.
I'm very confused about KEEPFILTERS VS ALL(ALLSELECTED). Messed up my brain!
:) let’s see have a look here: ua-cam.com/video/rvpKSH3zRcg/v-deo.html
the first video i watched for power bi. Great one!
awesome, hopefully not the last one :D
Another amazing video by the guy that's better than Netflix! Thanks again Bas!
I have a question though: Is there a way to filter by using only part of the value and not the whole word? For example instead of finding all Sales for which [Product Category] ="Hair", can we find all Sales for every [Product Category] that contains let's say the letters "*AI*" somewhere in the [Product Category] field?
great video to get started, I wish I found this one earlier in my career. by the way, you missed the allselected() function to calculate sub totals that everyone else talks about all the time lol.
Great video!
quick question, How can we filter our visual by the value of the measure we created, let say we want to see specific range of Cost% to sales without creating calculated colomn?
Many thanks 🔥
Your are the best BAS. Just what I need.
Thank you, that was super informative! I will definitely use these tips in my daily work!
Thank you soooooo much!
Glad it helped!
Great video!!! Really important to understand this concept !
Hello, your videos are always very helpful...
Can you help me with the day to day % change. I was trying to do this for the share price analysis.
sure, think this will help get you there ua-cam.com/video/I8Y5fBGwqeQ/v-deo.html
That was informative and straight to the important points thank you
What is the difference between using REMOVEFILTERS() and ALL()?
thanks for explanation, this video really help me to understand the more about the difference.
You are welcome JC all the best!
Thank you, greetings from Perú.
All the best Hugo!
Now im curious why you wrote a variable at the end instead of writing another measure that used previously- created measures, like ‘total sales’ and ‘total sales ALL’. That is how I have been doing it 😮.
bit cleaner in my view - ‘total sales ALL i create here just for explanation purposes
Could you make a video showing how to create a stock price variation line chart that always start on 100% doesn’t matter the start date you select in the slicer?
Great stuff! But don't you think that the average sales by the customer should not be identical?
They bought on different occasions at different times so....
What that expression does is merely dividing the total sales by the number of customers in the customer table
I reckon instead of ALLcustomer as the first argument of AverageX we should use 'fctSales' instead.
Hi Bas! Thanks a lot for this video and all of them, i'm new at dax and your channel is being really useful.
I'm having trouble understanding context transition.
I've tried appying the calculate(sum()) formula, but it doesn't respect the calendar table filter. If i use a meassure it works correctly, but i think i need a calculated column with the amount, since the goal is to label the customer according to 3 categories for the amount of income of each one. Could you give a hint? thanks in advance.
Kind regards.
calculate(sum(salesamount)) should give you the same as a measure [Total Sales] .. not sure where you go wrong
Hi, is there a way to get a specific date values thru DAX e.g. getting the sales every 1st of the month then comparing it with current sales value. I tried using CALCULATE and FILTER but the 1st day sales only shows on the total rows but doesn’t show up on each rows. It will only show the per row values if the selected report date is 1st of the month. Hope you can cover it in your future video
Thanks Man
Where can I get the raw files for practice. Customer tbl , product tbl , sales tbl?
how much SQL knowledge is required for Power BI developers with 2 to 3 years of experience, and in an organization, do Power BI developers have to handle SQL tasks themselves or is there a dedicated SQL team for that?
This was really useful, thank you!
@12:49 how can this average sales at customer level ? Its simply average sales of all customers. Its the same result.
Such a golden video! Thanks a million.
Thanks Bas! As always, making sure I don't get too sloppy with my DAX.
thx for watching Rick!
Thank you. Very useful
Nicely explained. Thanks a lot for the useful content.🔥
9:30 - How does the calculate function 'know' that it's by 'Customer Name' and not by e.g. 'Customer Segment' or 'City'?
Loving too much your videos and explanations. Congrats
Hi I have a power bi question. My rows are different places and my columns are different toys sold at those places. I want to measure a specific toy and check what they did in Q1 and Q3 in year 2021 and next to it before the next toy I want to see Q1 and Q3 year 2022. However when i do that the 2022 only starts after all the quarters of the previous year is filled how do I put both years together as a measure to see If I am profitable?
Hello Bas, thanks for your videos, I learned so much. Can you share also the name of the cream or hair product you use in your hair? Its really nice. 😊
haha lol! of course 😉 .. Layrite original pomade, spray, and beard oil
@@HowtoPowerBImany thanks Bas ❤🎉 I have already requested 😂
Killer content as usual Bas. If only video's like this were around when I started trying to learn Dax!!!
Thank you so much Peter, that's really nice to here! 😊
Your channel is underrated
Really helpful and great instructional video Bas!
Great tutorial. Straight to the point and everything was explained clearly.
Amazing
I got the Dax summary in 20 minutes thanks
hope dax will be easy(ier) from here on now :D - thx for watching Jigs!
Great video!
In the last example, would it not be better to remove all filters on the dimCustomer table and not just on Customer Name that may not even be unique? There may still be a filter on customer no or customer id or something.
if you would add a further breakdown to the visual (for example customer segment) it would lead to a different result (% of overall total vs subtotal) .. just depends on what you are looking for -> work with the minimum number of columns to reach your goal
I adore your work man!
great overview...thanks
Note to my past self:
1) If you want to use the result of a calculation as a filter, then your calculation must be performed within a calculated column (as shown in this video).
2) If you want your result to itself be sensitive to the use of filters, then your calculation must be performed within a measure.
Thanks
thanks a lot John!
Dax is easy, its all about methods that's take argument and read table and return value and the parameters can be anothe method "pipeline"
guess it depends on who you ask ;)
Wunderbar 👍
Super
Bas🎉
Vielen Dank
Danke!
Thanks for watching and your support :)
Please make a video about APIs!
I have too much data without PBI connections (as Google sheet, we use Zoho mail). And it has been a painful journey to work like this lmao
I still cannot get my head around this. So I started tampering with the same expression and when I applied the same code but without the calculate the same numbers were returned for customers regardless of whether I used Allcustomers or just Customers. It seems that the row context of fctsales[sales], which is a calculated column, overrides the preceding row context on customer, that is Allcustomer behaves the same as customer alone. If you could please clarify this would appreciate it.
Thanks for this I have no more compliments for you anymore lol, you are now officially powerbi legend lol
How am I just now finding this channel a year late?!
How, indeed ;)
@@HowtoPowerBI I'm trying to make up for it by sharing with my colleagues now as well. Our whole group had just started using Power BI in a big way, and even with a strong excel background, I'm finding DAX challenging.
Great magic show
🧙♂️😊
Is it possible we can show Top 5 and Bottom 5 sales in one chart. If yes how. Please make a video on this
Thanks in advance
Basic question...Is DAX case sensitive?