DAX formula to define monthly value from the highest value of week in month

[Anonymous]

Dear all,

May I ask your advice for below issue.

Expectation: define monthly value from the highest value of week in month

                    Example: in July 2022 have 5 weeks: Wk27, 28, 29, 30, 31, 32

                                    I have 2 factory A and B

                                    Then I want to create a DAX formula returns value of July 2022 for each factory is the value of week have the highest value in month. As data below it should be 22,411 for factory A and 11,533 for factory B. 

Issues: my formula return in accurate value, below is the current result with my DAX. It should be 22,411 for factory A not 21,761.

DAX: 

Max of month = calculate(maxx(SUMMARIZE('Calendar','Calendar'[Year.Week]),

[Stock projection])

)

Appreciate your advice what is wrong with this formula.

Thanks so much!

[amitchandak · Accepted solution]

@Anonymous , Try like

Sumx(Values(Table[Week]), Maxx(Table,[Stock projection]))

or

Sumx(Values(Table[Week]), Maxx(values(Table[Week]) ,[Stock projection]))