Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |