Forum Discussion

Zx2000's avatar
Zx2000
Icon for Advocate I rankAdvocate 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. 

Zx2000's avatar
Zx2000
Icon for Advocate I rankAdvocate I
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.