Advanced DAX interview questions, Advanced DAX Queries, Advanced DAX tutorial, Advanced DAX tutorial pdf, Analysis Services, Context in DAX, DAX, DAX Common Interview Questions, DAX Common Interview Questions and answers, DAX FAQ, DAX FAQs, DAX Formatter, DAX Interview Q & A, DAX Interview questions, DAX Microsoft, DAX Parameter Replacer, DAX Patters, DAX Queries asked in interviews, DAX questions, DAX Server, DAX Server - General Interview Questions and Answers, DAX Server developer Interview questions and answers, DAX Server developer Interview questions with answers, DAX SERVER Interview questions, DAX SERVER Interview questions & Answers, DAX SERVER Interview questions and Answers, DAX Server Interview Questions and Answers - Free PDF, DAX SERVER Interview questions and answers for experienced, DAX server interview questions and answers for net developers, DAX SERVER Interview questions for experienced, DAX SERVER Interview questions pdf, DAX SERVER Tips, DAX SERVER Tricky questions, DAX SSAS, DAX Tabular, DAX Tips & Tricks, DAX Tips and Tricks, DAX Tricks, DAX Tricky Question, DAX Tutorial, DAX Utility, Difficult DAX Interview Questions, Download DAX Questions, Download DAX Server Interview Question in PDF, Download DAX SERVER Interview questions, download DAX server interview questions and answers, download DAX server interview questions and answers pdf, download DAX server interview questions by Pawan Khowal, download DAX server interview questions by Pawan Kumar, download DAX server interview questions by Pawan Kumar Khowal, Download T-DAX Interview Questions, Dynamic Analysis Expressions, Free Download DAX SERVER Interview questions, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Queries for SQL Interview, T-DAX, T-DAX Interview questions, T-DAX Programming, T-DAX Server Interview Questions, T-DAX Tutorial, Tabular Model, TOP 100 DAX SERVER INTERVIEW QUESTIONS, Top 50 DAX Server Questions & Answers, Tough DAX Interview Questions, Tough DAX Queries, Tough DAX Queries Interview Questions, Tough DAX Questions, Tough PL DAX Interview Questions, Tricky DAX Interview Questions, Tricky DAX Interview Questions and answers, Tricky DAX Queries for Interview, Tricky DAX SERVER Interview Questions and answers, TSQL Interview questions, What is context in DAX, What is DAX?
DAX with Tabular Model Series – What is a Context in DAX?
Context basically used to perform dynamic analysis, in which the results of a formula can change to reflect the current row selection and also any related data.
Understanding context and using context effectively are critical for building high-performing, dynamic analyses, and for troubleshooting problems in formulas.
Context is also called as Evaluation Context
There are following types of context-
- Row context
- Query context
- Filter context
Filter context is the set of values allowed in each column, based on filter constraints that were applied to the row or that are defined by filter expressions within the formula. In simple terms you can consider filter context as a set of conditions in a WHERE clause of a SQL SELECT statement.
For example, check out a sample SQL statement and Equivalent DAX
-- SELECT ColorType FROM Colors WHERE ColorType <> -1 --
-- EVALUATE ( FILTER ( VALUES('[Colors]'[ColorType]), ColorType <> -1 ) ) --
Check out the picture above – DAX
Evaluate is the keyword from where we should start our query. Values clause is used to return distinct column values. It will simply discard the duplicate values and filter used in this query is used as a where clause used to filter out rows where ColorType <> -1. I will explain Row context and query context in the upcoming posts !
This is the small information about Context in DAX. I will some posts about how context works and row & query context.
That’s all folks; I hope you’ve enjoyed learning about Context in DAX, and I’ll see you soon with more “DAX” articles.
Pawan Kumar Khowal