Is it somehow possible to summarize a summarized table? I can't make it work with summarize(summarize(...)...)

e.g. I have a table with columns: user, day, value, (month)

=> summarize this by user, month and calculate the value per month

Now I want to find the maximum value per month per user. I can easily calculate this with maxx.

But in the end im interested in the count of the max value per user per month which is e.g. >x. From my understanding i would need to summarize the table user, month, value per month and calculate a new column with maxx(value per month)...

At the moment i solve the problem by having a pivot table in excel with user, maxx(value per month) and than counting the values >x.

Hope you understand what i mean. Still pretty new to Powerpivot/DAX.

Thanks