Forum Discussion

Zx2000's avatar
Zx2000
Advocate I
3 years ago
Solved

Calculate and filter context

Hello, I guess this is a simple question but I am going nuts why it doesn't work. So as far I studied DAX book and read your articles I know that if we add an filter as a CALCULTE argument adds a fi...
  • Zx2000's avatar
    Zx2000
    3 years ago

    So I found the solution. The solution is off course crazy becasue there is no clear information about this almost nowhere. Seems that DAX is real hell. So...as far as I understand: 
    If someone uses calculate with [date] column and:

    -[date] column is a connector to other tables  OR

    -if table is "marked as date table" (when a date table is connected with other table but by other column ie. DateKey)

     

    => the ALL('date table") is added to the formula. This happend in the background (and of course almost no one knows it and you will not see it). Congrats for DAX developers. 

FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi Zx2000 

It is because a filter arugment inside a CALCULATE can overwrite outer fitlering context of a measure. In case of conflict, the filter argument prevails. 

Zx2000's avatar
Zx2000
Advocate I
3 years ago

Nope. It is wrong. They overwrite filter when filtering the same column. There is no confilct here. There is a outer filter context (year - month) and new context (single date). In normal case it should be combined.