---
type: learning
area: learning
status: learning
date: 2026-05-03
created: 2026-05-03
updated: 1980-01-01
tags:
  - learning
---
#### Expanded tables
![[img-20250707-003445-d07e400d.png]]

![[img-20250707-004320-d42c3774.png]]

Note that calendar lookup is also part of expanded table

#### Context Transition

Process of turning row context into filter context

Example 

Just a simple 2 Measure like:

Measure 1
``` dax
SUM Quantity Sold =
SUM(
    'Food Inventory'[quantity_sold]
)
```
Measure 2
``` dax
SUM Quantity Sold (Calculate) =

CALCULATE(

    SUM(

        'Food Inventory'[quantity_sold]

    )

)
```
![[img-20250707-010747-650880ec.png]]

Normally Measure 2 where filter context is applied because of the use of calculate but when applyin both on a matrix we are getting the same result? why that because automatically dax engine applies implecitly Calculate to the 1 measure and teh cotext is derived from row using context transition

Automatically calculate change any row context to filter coontext

#### Evaluation Order

No Modifiers

![[img-20250707-011335-10164565.png]]

With Modifier

![[img-20250707-011609-769b654a.png]]

Both gave the same result because in second measure the modifier is overwritten

![[img-20250707-011659-0645e76b.png]]

Dax engine combine multiple filter contex into one