cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shep123 Frequent Visitor
Frequent Visitor

Filter by Total Column Sum per Campaign

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

 

CampaignClicksImpressionsSessions
a001
b0010
c005
a1416,0000
b1011,0000
c1213,0000

 

When I create by matrix I get the following:

CampaignClicksImpressionsSessions
a1416,0001
b1011,00010
c1213,0005

 

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. 

CampaignClicksImpressionsSessions
a1416,0000
c1013,0000

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-yulgu-msft
Microsoft

Re: Filter by Total Column Sum per Campaign

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:

5.PNG

 

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

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Microsoft v-yulgu-msft
Microsoft

Re: Filter by Total Column Sum per Campaign

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:

5.PNG

 

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

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

shep123 Frequent Visitor
Frequent Visitor

Re: Filter by Total Column Sum per Campaign

@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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)