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 ...
Almost there but apparently the fields (all three) are text and it must be a number. Now I tried to change it in the table using Change Type but I am getting other issues. Is it possible to change the fields to number in DAX? I tried the following and it failed:
Sumx(summarize(Table, VALUE(Table[Year]) , VALUE(Table[Week]), "_1", Max(VALUE(Table[WestPac]))),[_1])