DAX Logic for Measures

[Drakorv]

Hi everyone, I have a little question that I'm not sure why the formulas work like this. I have a measure that calculates Stock (In - Out). Here are the measures:

Stock Historico = CALCULATE([Stock];FILTER(ALL(Calendario);Calendario[Date]<=MAX(Calendario[Date])))

Stock Historico2 = CALCULATE([Stock];FILTER(ALL(Calendario);Calendario[Date]<=[Max]))

Max = MAX(Calendario[Date])

Both measures "in theory" do the same, but they work differently. I'm not totally sure why. When I use the "Max date" previously defined in another measure [Max], it is affected by the ALL filter I have, but when I use the base formula MAX([Date]) in the calc, it isn't. Do you know why?

Thank you very much in advance

[Jihwan_Kim]

Hi, @Drakorv 

I am not sure about how your other measures look like, but I think,

the first measure -> it creates something like cumulate-total-pattern. because max(date) is inside the measure.

the second measure -> it calculates [stock] measure for all dates. because max(date) is coming from the outside of the measure and it is already defined as one date, which is the last date of all date table.  And all date that is less than or equal to max(date) is same as all date table.

I hope I explained well.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[Fowmy · Accepted solution]

@Drakorv 

In your 2nd Measure, you are using a measure named [Max]. Measures are always wrapped within the calculate function. This way, it always calculates the Maximum date overwriting the date column value.

In your 1st measure, MAX(Calendario[Date]) takes the outer row context from the visual on the date where no context transition happens.

Hope that made it clear.