Thanks for this article/video Marco. Filter context can be complicated, even for expert Dax developers. Articles like this are a must, getting back to the basics.
Thank you very much for the content. I believe that many of us who work with BI understand it better when it is explained visually. Screenshots, calculated results and drawings are quicker to understand than long tutorials in real time. For more videos like this! Thank you for this gift!
What an awesome graphical explanation of Filter context. Key is the Initial context and then the Target context and then using the correct CALCULATE measure
Really like the new way you presented in this video. The visuals make things very clear and easy to understand. I hope you can do more videos like this in the future. All your videos are good, but this could be even better.
Cheers sqlbi team, these explanations are mind-blowing. All the time in my bi journey, i could make sense of the actions behind the scenes of the filter context but felt hard to contemplate. Today it's head on.
This video shows how to make changes to filter contexts, but how do we know what the initial filter context is? Is it always explicitly defined in a measure? I'm concerned certain visuals or default summarization settings implicitly define contexts that can't be easily seen by clicking measures and seeing their dax formulas. For example if i come across a visual, shoui ld look in the fields to find definitions of measures to understand the starting context? How to make sure all existing filters are accounted for exhaustively? What other places can they exist in? (This video shows filter pane is a source of existing context too) For overwriting/keeping contexts does it propagate through the entire lineage of definitions? For example 16:06 shows Bnechmark 2017 measure depends on another measure Sales 2017 which depends on Sales Amount.
The purpose of DAX is to enable writing measures that work in any context. You can explore the filter context for debugging purposes with the debugger integrated in Tabular Editor 3, or by creating a special measure in the tooltip (DAX Studio has a feature to create it automatically) as described in www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/
in 3:07 minute. i try to sum manually using calcultor. sub sum is not proper with detail number. i have get some condition. How to make it same , please advice
Nice video... great content .. Thanks.. in the last example data from net price 600 to 999 will it appear or get filtered.. if not please provide the explanation
Let's not forget that if the year used from a calendar dimension table is sorted by some other column of that table, also this sorting column is part of the filter. I learned this lesson in the hard way 😢
Great explanation as always Marco. What is the reason in case I want to calculate sales amount that is not blue, but want to use color slicer and that gives me a static value and not filtered by the color slicer. Not Blue Measure = CALCULATE([Sales Amount], 'Product'[Color] "Blue"). I had to use KEEPFILTERS or FILTER in order to work and use the slicer. Thanks!
How do you filter a virtual table inside a measure using a selectedvalue from a disconnected slicer? The filtered table returns no data - as if the selectedvalue were returning multiple values - but it is not! If I put a default value in the selectedvalue variable it works as expected, and likewise if I return just the selectedvalue variable - it dynamically shows the value selected in the slicer. Yet the selected value doesn't seem to be recognized when used to filter the virtual table. Help!?
SELECTEDVALUE returns a single value, you should use VALUES to get all the selected values. Indeed, SELECTEDVALUE internally uses VALUES; as described in dax.guide/selectedvalue/
In the last example, with both net price 1,000, you said that 'both remain'. Different results depending if this means they are a union or an intersection. I will test this myself eventually but can't for a few days
Different filters in the filter context are always in an AND condition - remain means that you get an intersection because of the AND condition between filters.
Should we always use KEEPFILTERS? My question is based on the assumption we cannot control if an user adds an external filters, for example just for filter a location or an year... if in our measure we use the "same filter", we overwrite the user filter... so isn't it safer to always use it?
me costo un poco seguir el video ya que lo veo con subtitulos en español, asi que lo repeti y detuve hasta entender un poco... seria muy bueno que se pudiera traducir los videos a diferentes idiomas. Saludos desde Colombia.
"Filter is a table" - i so needed to hear this! Thank You so much!
Love those visual representation. Truly a picture is worth a thousand words. Combined with clear and precise explanation. Priceless.
Visually representing the Filter context is a great way to understand the filter/data flow. Thank you for the great explanation.
Thanks for this article/video Marco. Filter context can be complicated, even for expert Dax developers. Articles like this are a must, getting back to the basics.
Thank you very much for the content. I believe that many of us who work with BI understand it better when it is explained visually.
Screenshots, calculated results and drawings are quicker to understand than long tutorials in real time.
For more videos like this! Thank you for this gift!
This is such an spectacular explanation. You are a fantastic teacher. Thank you!
Clearest explaination for this concept I have ever seen! Thanks guys, this is great
Accidentally discoverd this Channel. I'd say that the in-depth explanation of how DAX work is excellent ! Thank you very much for you work ! 💐💐
You don't know how much I needed this video at this particular moment!
What an awesome graphical explanation of Filter context. Key is the Initial context and then the Target context and then using the correct CALCULATE measure
Wow. I never comment on videos, but this one was actually very, very helpful. Yes. More colorful, simple visuals to convey complex info. :) Kudos!
Absolute legends! This is a wonderful resource to learn from and especially to share with new developers!
Very clear explanation of an often bypassed topic by beginners. Excellent content as always!
For a visual learner like me, this is very helpful!
As always you videos are blessing for people like me who are starting to learn and really understand DAX better. Thanks ❤
This is beatiful. You are stepping up your visauls game. Way to go, looking forward to more!
Thank you, SQLBI! Great explanation
Un video spettacolare... Marco spiega in modo magistrale¡¡¡
Really like the new way you presented in this video. The visuals make things very clear and easy to understand. I hope you can do more videos like this in the future. All your videos are good, but this could be even better.
Fantabulous way to explain filter context. Love it
The visuals (Whiteboard) really helped, thanks!
Thanks for such a detailed explanation! Very useful and interesting.
Cheers sqlbi team, these explanations are mind-blowing. All the time in my bi journey, i could make sense of the actions behind the scenes of the filter context but felt hard to contemplate. Today it's head on.
Most awaited video. BDW I have read your DAX book. Thanks❤
Marvellous explanation! Many thanks!
Thank you very much Marco. Fantastic explanation as always 😄
Thank you so much, it helped clear up a lot of confusion about filters.
great video! please, keep doing these visual representations.
what a great explanation, Thank you
Great video !!! Thanks for sharing, Marcelo, Buenos Aires, Argentina
I still get wrapped around the axle sometimes when it comes to filter context. This video helped to clear a few things up.
Thanks.
Awesome explanation. Loved it.❤❤
Nice explanation. Can we have row context and context transition videos in same format.
Thank you
Coming in July/August!
Thanks. Enjoying DAX.
Ottimo lavoro, come sempre!
Amazing explanation. Thanks!!
Brilliant tutorial, thanks!
Brilliant explanation!
Well explained sir!!! Thank you!!
Finally the so waited pedagogical paradigme shift from Sqlbi
Nicely done Marco
This video shows how to make changes to filter contexts, but how do we know what the initial filter context is?
Is it always explicitly defined in a measure? I'm concerned certain visuals or default summarization settings implicitly define contexts that can't be easily seen by clicking measures and seeing their dax formulas.
For example if i come across a visual, shoui ld look in the fields to find definitions of measures to understand the starting context?
How to make sure all existing filters are accounted for exhaustively? What other places can they exist in? (This video shows filter pane is a source of existing context too)
For overwriting/keeping contexts does it propagate through the entire lineage of definitions? For example 16:06 shows Bnechmark 2017 measure depends on another measure Sales 2017 which depends on Sales Amount.
The purpose of DAX is to enable writing measures that work in any context. You can explore the filter context for debugging purposes with the debugger integrated in Tabular Editor 3, or by creating a special measure in the tooltip (DAX Studio has a feature to create it automatically) as described in www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/
in 3:07 minute. i try to sum manually using calcultor. sub sum is not proper with detail number.
i have get some condition.
How to make it same , please advice
Nice video... great content .. Thanks..
in the last example data from net price 600 to 999 will it appear or get filtered.. if not please provide the explanation
Let's not forget that if the year used from a calendar dimension table is sorted by some other column of that table, also this sorting column is part of the filter. I learned this lesson in the hard way 😢
Very nice video and well produced
Filter Context NOT a myth anymore. #SQLBI team never disappoints us.
Great explanation as always Marco. What is the reason in case I want to calculate sales amount that is not blue, but want to use color slicer and that gives me a static value and not filtered by the color slicer. Not Blue Measure = CALCULATE([Sales Amount], 'Product'[Color] "Blue"). I had to use KEEPFILTERS or FILTER in order to work and use the slicer. Thanks!
I didn't quite understand the last example. Are the net price items with value above 600 going to be used in the calculation?
No, because all filters (the orange one and the blue one) are active at the same time.
How do you filter a virtual table inside a measure using a selectedvalue from a disconnected slicer?
The filtered table returns no data - as if the selectedvalue were returning multiple values - but it is not! If I put a default value in the selectedvalue variable it works as expected, and likewise if I return just the selectedvalue variable - it dynamically shows the value selected in the slicer. Yet the selected value doesn't seem to be recognized when used to filter the virtual table. Help!?
SELECTEDVALUE returns a single value, you should use VALUES to get all the selected values. Indeed, SELECTEDVALUE internally uses VALUES; as described in dax.guide/selectedvalue/
In the last example, with both net price 1,000, you said that 'both remain'.
Different results depending if this means they are a union or an intersection. I will test this myself eventually but can't for a few days
Different filters in the filter context are always in an AND condition - remain means that you get an intersection because of the AND condition between filters.
Phenomenal
Thanks.
Fantastic!
why is the sum of the various amount for the colors not equal to the contoso amount
bravo¡ SQLBI
Should we always use KEEPFILTERS? My question is based on the assumption we cannot control if an user adds an external filters, for example just for filter a location or an year... if in our measure we use the "same filter", we overwrite the user filter... so isn't it safer to always use it?
It depends, see www.sqlbi.com/articles/best-practices-for-using-keepfilters-in-dax/
@@SQLBI Thank you!
Wow, I think I might actually kinda understand this concept now. 😅
me costo un poco seguir el video ya que lo veo con subtitulos en español, asi que lo repeti y detuve hasta entender un poco... seria muy bueno que se pudiera traducir los videos a diferentes idiomas. Saludos desde Colombia.
We evaluated that, but it's too expensive for now. UA-cam will likely implement not too far in the future.
Row context visually please 😂
Coming in July/August!
Tchau
Not clear