Issues using summarize in a measure

[Anonymous]

Hello all,

I have quite a complicated measure which isn't working as I'd expect.

Firstly, I'm creating a summary table in the measure. This table calculates a running average of the values I have in an existing table.

It does this by creating a  new column which is an average of the value on that row and the values following. I have tested the summarize calculation in a calculated column and this works very well.

However, when I put the same calculation in a measure and ask the measure to report (for example) the maximum value of the running average, things break down.

If I use the measure in a table to restrict the input then the measure value stays exactly the same -- no matter what filters I apply.

Is the summarize function limited to create a 'static' summary table? How can I get the measure to work.

I'm able to supply code if needed but thought I'd ask this general question first.

Thanks,

Wiredchop

[Greg_Deckler · Accepted solution]

I wrote this article to solve a very similar sounding issue, get the MAX/MIN of an AVERAGE. Let me know if this works and if not, post your code:

https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

[Anonymous]

Fantastic,

fixed my formula by using maxx(summarize(...),...)  rather than calculate(max(...),summarize(...))

Is there an important reason why to use maxx in this situation?

Thanks for your help,

Wiredchop

[Greg_Deckler]

Well, essentially the "X" verssions of those are effectively doing a kind of table scan that evaluates the expression for each row and returns the largest or smallest numeric value out of the scan of those rows.

https://technet.microsoft.com/en-us/library/ee634576(v=sql.105).aspx