Antriksh - fantastic video! Wonderful examples, and the clearest explanation of this critical but complex topic that I've heard to date. Thank you for the obvious time and thought that went into this.
Red Sales 3 expression is unable to ignore the initial filter context of color when applied in matrix visual though it works in card. Nested calculate Red Sales 2 is more appropriate.
Hi Ivan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Hi Cesar, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Hi, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Great video and some very cool examples. My style of DAX coding includes:" 1. I taught my self the lesson that never filter a table if you can filter a column (which you always can). 2. Seeing code like FILTER ( Sales..... ) or ALL (Sales ) should always activate the warning signs because this activates the expanded tables concept. The expanded fact table often contains the entire datamodel if you work with star schema. 3. I try to avoid expanded tables as much as I can. I always work with CROSSFILTER if I need to filter many side to one side in a datamodel. Question for you:" I have actually never seen examples where the expanded tables calculate inacurrate results? I mean values that are wrong. I have only seen examples (like yours) where it returns blank because you one doesnt understand how filters are evaluated in the filter context. Are there scenarioes to be aware of in terms of that? Thanks in advance!
Hello Lasse, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. And we really appreciate you sharing your learning process. We'll try and create content based on furthermore scenarios based on the ideas that you've projected but for now we're not in a position to comment on any specific scenario since it also depends upon how one's data model is structured and what end results one is trying to achieve. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also, make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html www.linkedin.com/groups/12004506/
Hi Viktor, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
So is there ever a need to use an expanded table rather than just using single column filters on a fact table? Or was the point that we should never use expanded tables because they’re unnecessarily complicated? Would’ve been good to get an example of using an expanded table where there is no other option. This was very informative nonetheless. I didn’t know about the order of operations where multiple calculates exist.
Hello dg515, Thank you for posting your feedback onto our channel. We really appreciate you taking your valuable time to post it. And we'll surely create a content based on your valuable suggestion that you've provided. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also, make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html www.linkedin.com/groups/12004506/
Hi, glad that you appreciated our content! All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers! portal.enterprisedna.co/
Hi readi street, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Hi! Glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!
Red Sales 3 expression is unable to ignore the initial filter context of color when applied in matrix visual though it works in card. Nested calculate Red Sales 2 is more appropriate.
Any recommendations which of the 2 (working) measures in this example to choose from a performance perspective ? Or no difference ? Thanks for the very clear video !
Red Sales 3 is fastest in any scenario as far as I have tested, when we start nesting measures, the engine can't solve the nested iterators without materializing the whole table, it can be a huge filter, so in those scnearios it is better to materialize 1 column than 20-30 columns, also the expanded table filters are already complex on the DAX engine in their basic usage as well.
Hi Jan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!
Hi Matteo, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
20:13 I don’t understand why he says “we dont have a filter over the calendar year” as he highlightd RELATED (Dates[Calendar Year Number] ) = 2008 Isn’t that a filter?
On second thought, he’s probably saying there’s no direct filter on the dates table like Dates[Calendar Year Number] = 2008 right below COUNTROWS ( Dates )
@@rdg515 That's right. When I use RELATED I am only checking for each row if the row on the One side is for 2008 but visually there is no Filter over Dates even though we are using expanded table to filter Dates as well.
Hi Jerome, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Hi, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
The grand total is correct because only 2353 CustomerKey participate in the relationship with the sales table, sorry for the confusion I should have mentioned that in the video. At the grand total there is no filter so a DISTINCTCOUNT for all the categories show how many unique customers are there in the Customers table.
@@venkatareddykummitha5863 Yup, I mean the number of customers that have a transaction in the Sales table are only 2353 :) Rest do not have any transaction. Also when you run the query you will see that the DAX Engine is doing a DISTINCTCOUNT while calculating customers.
Antriksh - fantastic video! Wonderful examples, and the clearest explanation of this critical but complex topic that I've heard to date. Thank you for the obvious time and thought that went into this.
Thanks a lot Brian! :) For the appreciation and the platform!
Red Sales 3 expression is unable to ignore the initial filter context of color when applied in matrix visual though it works in card. Nested calculate Red Sales 2 is more appropriate.
Thank you Antriksh!
It was nice and clear explanation!
Hi Ivan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Thanks! :)
Amazing!!!!! Best Regards From Mexico.
Thanks! :)
Hi Cesar, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
EXCELLENT . STEP BY STEP .... AWESOME..
Thanks! :)
Hi, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Great video and some very cool examples. My style of DAX coding includes:"
1. I taught my self the lesson that never filter a table if you can filter a column (which you always can).
2. Seeing code like FILTER ( Sales..... ) or ALL (Sales ) should always activate the warning signs because this activates the expanded tables concept. The expanded fact table often contains the entire datamodel if you work with star schema.
3. I try to avoid expanded tables as much as I can. I always work with CROSSFILTER if I need to filter many side to one side in a datamodel.
Question for you:" I have actually never seen examples where the expanded tables calculate inacurrate results? I mean values that are wrong. I have only seen examples (like yours) where it returns blank because you one doesnt understand how filters are evaluated in the filter context. Are there scenarioes to be aware of in terms of that?
Thanks in advance!
Hello Lasse,
Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. And we really appreciate you sharing your learning process.
We'll try and create content based on furthermore scenarios based on the ideas that you've projected but for now we're not in a position to comment on any specific scenario since it also depends upon how one's data model is structured and what end results one is trying to achieve.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Also, make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Great video, thanks
Thanks! :)
Hi Viktor, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Just wonder how it will look like if DAX debugger was used.
Great suggestion! I haven’t tried it yet and this will be a great example to test.
So is there ever a need to use an expanded table rather than just using single column filters on a fact table? Or was the point that we should never use expanded tables because they’re unnecessarily complicated? Would’ve been good to get an example of using an expanded table where there is no other option.
This was very informative nonetheless. I didn’t know about the order of operations where multiple calculates exist.
Hello dg515,
Thank you for posting your feedback onto our channel. We really appreciate you taking your valuable time to post it. And we'll surely create a content based on your valuable suggestion that you've provided.
For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well.
Hoping you find this useful. Also, make sure that you're subscribed to our TH-cam channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes.
Cheers,
Enterprise DNA
forum.enterprisedna.co/
th-cam.com/channels/y2rBgj4M1tzK-urTZ28zcA.html
www.linkedin.com/groups/12004506/
Give the pbix file we need practice
Hi, glad that you appreciated our content! All pbix file/datasets are available for download in the Enterprise DNA Online, which is accessible via Membership. Check out the link below. You can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
portal.enterprisedna.co/
Great presentation! Thanks for sharing. Thumbs up!!
wow, excellent explanation!
Hi readi street, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
Excellent excellent
Hi! Glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!
Red Sales 3 expression is unable to ignore the initial filter context of color when applied in matrix visual though it works in card. Nested calculate Red Sales 2 is more appropriate.
Any recommendations which of the 2 (working) measures in this example to choose from a performance perspective ? Or no difference ? Thanks for the very clear video !
Red Sales 3 is fastest in any scenario as far as I have tested, when we start nesting measures, the engine can't solve the nested iterators without materializing the whole table, it can be a huge filter, so in those scnearios it is better to materialize 1 column than 20-30 columns, also the expanded table filters are already complex on the DAX engine in their basic usage as well.
Hi Jan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!
a very clear and useful explanation, thank you for conveying so clearly a concept that is quite difficult for me
Hi Matteo, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
20:13 I don’t understand why he says “we dont have a filter over the calendar year” as he highlightd RELATED (Dates[Calendar Year Number] ) = 2008
Isn’t that a filter?
On second thought, he’s probably saying there’s no direct filter on the dates table like Dates[Calendar Year Number] = 2008 right below COUNTROWS ( Dates )
@@rdg515 That's right. When I use RELATED I am only checking for each row if the row on the One side is for 2008 but visually there is no Filter over Dates even though we are using expanded table to filter Dates as well.
Great video, I found the "boring" stuff to be the best part of you video ! Very well done.
Thanks! :)
Hi Jerome, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!
Thank you very much guys this is probably the best explanation of this important concept 👏
Hi, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
But the total is wrong at Total Level in CALCULATE( COUNTROWS(Customers), Sales).
The grand total is correct because only 2353 CustomerKey participate in the relationship with the sales table, sorry for the confusion I should have mentioned that in the video.
At the grand total there is no filter so a DISTINCTCOUNT for all the categories show how many unique customers are there in the Customers table.
@@AntrikshSharma customers key participants means Customers.
@@venkatareddykummitha5863 Yup, I mean the number of customers that have a transaction in the Sales table are only 2353 :) Rest do not have any transaction. Also when you run the query you will see that the DAX Engine is doing a DISTINCTCOUNT while calculating customers.
Does it FILTER fx. takes columns from same table without taking RELATED function.
@@venkatareddykummitha5863 Sorry, I didn't understand the question.