Help on Meassure

[Anonymous]

Hi,

Im trying to get this meassure to work. [SO Net] in other years like 2021, or 2022, should only be untill week 8...
I'm not able to 

SO Max Week = 
VAR MaxYear = MAX('DB'[Year])
VAR MaxWeek = CALCULATE( MAX ( 'DB'[Week] ),'DB'[Year] = MaxYear )
VAR Result = CALCULATE( [SO Net], 'DB'[Week] <= MaxWeek )
RETURN
Result

Only writing values direclty makes it work:

SO Max Week = 
VAR MaxYear = 2022
VAR MaxWeek = 8
VAR Result = CALCULATE( [SO Net], 'DB'[Week] <= MaxWeek )
RETURN
Result

[v-zhangti]

Hi, @Anonymous 

If your question is still open, is it possible to provide some of the example data? What do you expect the output to look like, and also pictures to show the following, thanks.

Best Regards

[VahidDM]

HI @Anonymous 

Try this:

SO Max Week = 
VAR MaxYear = MAX('DB'[Year])
VAR MaxWeek = CALCULATE( MAX ( 'DB'[Week] ), Filter(all('DB'),'DB'[Year] = MaxYear )))
VAR Result = CALCULATE( [SO Net], 'DB'[Week] <= MaxWeek )
RETURN
Result

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/