9 - Evaluation Context - Row Context
Hi Learners,
In this video , I have explained ROW context, which is another evaluation context used by Power BI and Power Pivot.
Row context iterates over the table in a calculated column. DAX creates an implicit row context in case of calculated column. It is like a cursor as in SQL. There is no need to manually create a row context.
The row context refers to a particular row in the DAX code at any given point in time.
It is different from the row of the underlying table. The data presented in the table or matrix visual is the result of filter context, not the row context
Apart from the implicit row context in calculated column, there is only one way of creating a row context, which is using iterator functions in DAX.
Measure does not have an implicit row context. It can be started using an iterator function.
Row context is not a special type of filter context. It never filters the model. Filter context filters and row context iterates.
To know more, please watch this video.
To learn more about DAX and Power BI, please subscribe to our channel ML For Analytics.
/ mlforanalytics
To know more about our blog and the topics related to business intelligence and data science, please visit the following link:
https://mlforanalytics.com/