If you use DAX in power bi to any extent then it is very crucial for you to understand Row Context & Filter Context, which are essential for constructing any type of DAX function. Today we will do a deep dive into these concepts and see how we can use them to construct any DAX much more efficiently. Lets go!
Data Used
Row Context
It refers to the current row being evaluated in a table or column. When you create calculations or measures in Power BI, the calculations are typically performed in the context of the rows being processed. Each row in a table can have its own context, which can influence the results of calculations and measures.
Filter Context
It refers to the set of filters that are applied to the data when evaluating calculations or measures. These filters can come from various sources, including slicers, filters applied directly to visuals, or implicit filters based on relationships between tables.
Comentarios