contexts in power bi

[sudhav]

How many types off contexts in power BI? please answer me someone, thankyou

[v-yanjiang-msft · Accepted solution]

Hi @sudhav ,

There are different types of context: row context, query context, and filter context.

Row context can be thought of as "the current row.” If you have created a calculated column, the row context consists of the values in each individual row and values in columns that are related to the current row. There are also some functions (EARLIER and EARLIEST) that get a value from the current row and then use that value while performing an operation over an entire table.

Query context refers to the subset of data that is implicitly created for each cell in a PivotTable, depending on the row and column headers.

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.

Reference:Context in DAX Formulas

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Samarth_18]

Hi @sudhav ,

You can refer to the below links for a better understanding of the contexts in PBI:-

https://www.youtube.com/watch?v=A0sBJxCoXx8&ab_channel=EnterpriseDNA 

https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/ 

Thanks,

Samarth

[sudhav]

Actually this question is asked me in an interview, can you plese eloborate it sir, please

[vanessafvg]

now quite sure the context of your question is, but there are row contexts and filter contexts.   

What is it that you you trying to solve?