Forum Discussion
Max Value based on two categories
Need help trying to get a number based on the year and the week. I cannot just create a new measure in the original query but need to create a new measure in the visulization itself (data is detail ...
amitchandak
Super User
Super User
Sumx(summarize(Table, Table[Year] , Table[Week], "_1", Max(Table[WestPac])),[_1])
or
calculate(Sumx(summarize(Table, Table[Year] , Table[Week], "_1", Max(Table[WestPac])),[_1]), Filter(allselected(Table), Table[Year] = Max(Table[Year]) && Table[Week] = Max(Table[Week]) ) )