Topic: DAX
-
The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. Watch now
-
This video explains how to use KEEPFILTERS to intersect instead of overriding an existing filter context in DAX. Using FEEPFILTERS simplifies the code and improves performance. Watch now
-
Context transition is one of the most obscure topics for DAX newbies. Learn how it works, its effects, and how to leverage it rather than be scared of it. Watch now
-
This video introduces CALCULATE, the most powerful and complex function in DAX. Watch now
-
Understanding the difference between row context and filter context is the first and most important concept to learn to use DAX correctly. This video introduces the row context. Watch now
-
Learning DAX by examples is never a good idea! Watch why and get motivated in learning some theory first! Watch now
-
How can you display the measure as a percentage in a chart where the Y-axis shows the value? With the smart techniques shown in this unplugged video! Watch now
-
How do you analyze the country of different entities, like Customer and Store? In this unplugged video, we explore how to manage the analysis of geography attributes in different Power BI tables. Watch now
-
The new sparklines feature in Power BI retrieves more data. Does it impact performance? How does DAX retrieve the additional data points? Let’s discover it in this video! Watch now
-
Using ALLSELECTED with no arguments in a remote model later used in a composite model might produce unexpected results. In this video, we explain why ALLSELECTED requires special attention. Watch now