Forum Discussion
Solved
DAX GROUPBY each group
Hi, I have a table like below in Power BI: I want a table which return MAX(Rate) for each group, along with the group i.e. a table like below: How can I achieve this? Than...
Table 2 = VAR __tmpTable = SUMMARIZE('Table31',[Name],"__MaxRate",MAX('Table31'[Rate])) RETURN ADDCOLUMNS(__tmpTable,"__Day",MAXX(FILTER(ALL('Table31'),[Rate]=[__MaxRate]),[Day]))Table31 is my base table.
Maybe something like this:
Measure Rate = MAX([Rate])
Measure Day =
MAXX(FILTER('Table',[Rate]=[Measure Rate]),[Day])
Put these two measures in a table viz with [Name].
