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.
Go to 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:
Proud to be a Datanaut!
View solution in original post
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,
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.
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!