Filter by Total Column Sum per Campaign

[shep123]

I am having trouble by the total number of Impressions per campaign. Below is some sample data.

Campaign	Clicks	Impressions	Sessions
a	0	0	1
b	0	0	10
c	0	0	5
a	14	16,000	0
b	10	11,000	0
c	12	13,000	0

When I create by matrix I get the following:

Campaign	Clicks	Impressions	Sessions
a	14	16,000	1
b	10	11,000	10
c	12	13,000	5

This is perfect except as constructed but I want to add a filter that removes campaigns with Impressions below 12,000. When I go that I get the following table because it is filtering out the first records because their impressions are less than 12,000. 

Campaign	Clicks	Impressions	Sessions
a	14	16,000	0
c	10	13,000	0

Is there a way to build a filter off the total number of impressions unique to each campaign?

[v-yulgu-msft · Accepted solution]

Hi @shep123,

According to your desription, you want to filter the sum of Impressions for each Campaign which is greater than 12000 in matrix level, right?

If so, you can add visual level filters as below:

If I have something misunderstood, please share more information about your expected result and how to added filter.

Best regards,
Yuliana Gu

[shep123]

@v-yulgu-msft you are correct. I thought I did that previously which is why I asked the question. I must have had another filter somewhere else that was causing the issue. Works now though.