I am trying to use an aggregate measure as a filter on the table, but with no success. Let’s start from the beginning, I have created an aggregated measure that calculates the average of column A. This measure is dynamic which means there are filters that affect Column A. So, the average of Column A is not a standard value. After that I need to present the values of column A that are greater than or equal to the average, is this possible? If so, how can I do this.
in your title you ask for “filtering”, in the text you look for “presentation” of selected values.
I don’t know about a “filtering” solution in my VA 7.5 as the average (in the aggregated measure) would be recalculated with each filtering, so even theoretically one would get only a iterative process.
But there might be a presentation solution:
I can use the aggregated measure of the average in a Display rule, to white all rows with my Column A value less then the average:
If this isn’t sufficient and you have a new VA Version, maybe you will find an approach here:
Thank you for your reply.
If I have understood correct there is one way to present the values of Column A which is greater than or equal with the average is via display rules.
Also, I have tried to create a new aggregated data source, but I cannot use average (aggregated measure) as a filter.
(the photo is from SAS Visual Analytics Advanced Calculations (part 3... - SAS Support Communities)
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.