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.
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 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.
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 ?
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.
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....
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?
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.
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.
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.
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.
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
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.
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
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 😮.
Hey Dude, awesome video. I support what you do but I also have a suggestion, could you please take a bit less real estate for your face and more for the content this way viewers on a smaller screen benefit from your content.
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.
Hello, Sir.. Thank you for this amazing video i think i could try this to make multiple lines.. But, cant we really make multiple lines on combo chart and used the category as the legend of the lines?😢 I really struggle with this problem. I would be really grateful if you can help me🥲🙏
@@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.
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 🤝🙏🏻👍
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.
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.😀
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?
I am still confused what to do when it returned the same value as haircare for makeup and skincare? I have a similar situation .. Please can anyone help.