Відео

Marvellous explanation! Many thanks!

Very clear explanation of an often bypassed topic by beginners. Excellent content as always!

Finished watching

Finally the so waited pedagogical paradigme shift from Sqlbi

great video! please, keep doing these visual representations.

Brilliant explanation!

Good video and and agree with idea in behind, but what about Power BI tool it self? Is it easy to learn? Is it clear with what to start learn Power BI? Is it intuitive and how many exceptions in functionality need to keep in mind when You start to use it. So what is 20/80 needed to know in Power BI to get in average knowledge? Can be applied rules like 3/30/300 to Power BI tool it self? Sorry for to much questions above but its not fair that to create something simple and easy to read by going through madness to create it.

Excellent tutorial Kurt! Thanks to your clear guidance, it was easy to grasp how the reports could be more efficient and effective. Thank you for the content. Much appreciated!! Big fan of you guys :)

what is the purpose of using this: ISSELECTEDMEASURE (xxxx If you had another table and put total quantity on it, total quantity measure still changes. You have to stop interactions between the slicer and new table.

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!?

why can't I define a variable using selectedvalue from a disconnected slicer table to be used to filter a virtual table? It seems to think more than one value is being returned in the variable, when it is not. If I add a default value it works perfectly. If I return the selectedvalue variable it works perfectly, showing the selected value from the slicer. But when I try to filter the table using the selected value variable it returns no data. I know this is not a new issue, I just don't understand how to get around it! Help me Alberto - you're my only hope!

How do you limit selectedvalue to return only one value so that it can be used to filter a virtual table?

Un video spettacolare... Marco spiega in modo magistrale¡¡¡

awesome

Thank you for the video. I was able to follow along until you brought in Tabular Editor because I don't have it.

Absolute legends! This is a wonderful resource to learn from and especially to share with new developers!

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!

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.

Filter Context NOT a myth anymore. #SQLBI team never disappoints us.

The faster u create the file the stringent deadline will become.💀💀

7:45- why does Product to Brand need to be bi-directional? We have this second kind of bridge table in real estate: a borrower can have multiple collateral, and conversely, a collateral can be connected to multiple loan numbers (ie. pari-passu loans). So you need an intermediary loan-to-property code table between the Loan and Property tables. This is one-to-many-to-many-to-one, and it's uni-directional and it works just fine for Loan to filter Property.

3:00- bridge table type 1 (new information) (one-many--many-one) 7:30- bridge table type 2 (no new information) (many-one-one-many) (won't slow down your model if there are only a few hundred rows)

Love those visual representation. Truly a picture is worth a thousand words. Combined with clear and precise explanation. Priceless.

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?

Thank you so much, it helped clear up a lot of confusion about filters.

Thank you for the great lecture sir. Sir, I have one doubt. Above this, it is very useful to see month-wise. I tried the above concept month-wise and it successfully worked. But if I filter by 'Date[Date] in sales amount by date wise in chart, it does not work. Will we be able to find date-wise information for the above concept, sir? For example, if I clicked June 2024 in Slicer, the table showed the last 3 month values. If I filtered by 'Date'[Date] in the date-wise sales amount in the chart, the matrix table did not show the date-wise filtered value. It shows only that month wise Value . Kindly, give me solution for this concept Sir.

hey, I really like your videos. very useful, thanks for sharing 🙂

This is beatiful. You are stepping up your visauls game. Way to go, looking forward to more!

Thank you very much Marco. Fantastic explanation as always 😄

Wow. I never comment on videos, but this one was actually very, very helpful. Yes. More colorful, simple visuals to convey complex info. :) Kudos!

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.

Thanks for such a detailed explanation! Very useful and interesting.

Row context visually please 😂

Great video !!! Thanks for sharing, Marcelo, Buenos Aires, Argentina

Nice explanation. Can we have row context and context transition videos in same format. Thank you

Alléluia !!

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.

The visuals (Whiteboard) really helped, 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?

Very nice video and well produced

Thanks for taking the time to test ChatGRT-4o vs DAX. It's one thing for a typical developer to give their opinion, it's another for the Godfather to do so 🙂.

Fantastic!

I still get wrapped around the axle sometimes when it comes to filter context. This video helped to clear a few things up. Thanks.

Wow, I think I might actually kinda understand this concept now. 😅

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.

Awesome explanation. Loved it.❤❤

bravo¡ SQLBI

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

Most awaited video. BDW I have read your DAX book. Thanks❤