Forum Discussion
Issues using summarize in a measure
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
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
3 Replies
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
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