Forum Discussion
Filter Formula by Date
So what I was going for was
post Impressions 1 749479 2 749494 3 749509 4 749524 5 749539 6 749554 7 749569 8 749584 9 749599 10 749614 When you apply a Advanced filter to show lets say top 5, when you do a % of grand total it would normally take the result from that top 5.
I wanted to show only the top 5 BUT have the % total take from the 10 rows and be able to show it for a paticular month.
I actually figured it out and took a different route.
% of grand total= DIVIDE (
SUM ( 'Raw Data'[Impressions] ),
CALCULATE (
SUM ( 'Raw Data'[Impressions] ),
ALLSELECTED ( 'Raw Data'[Channel Title] ),
ALLEXCEPT ( 'Raw Data','Raw Data'[month_year] )
),
0
)
Hi,
Share some data and show the expected result.
So what I was going for was
| post | Impressions |
| 1 | 749479 |
| 2 | 749494 |
| 3 | 749509 |
| 4 | 749524 |
| 5 | 749539 |
| 6 | 749554 |
| 7 | 749569 |
| 8 | 749584 |
| 9 | 749599 |
| 10 | 749614 |
When you apply a Advanced filter to show lets say top 5, when you do a % of grand total it would normally take the result from that top 5.
I wanted to show only the top 5 BUT have the % total take from the 10 rows and be able to show it for a paticular month.
I actually figured it out and took a different route.
% of grand total= DIVIDE (
SUM ( 'Raw Data'[Impressions] ),
CALCULATE (
SUM ( 'Raw Data'[Impressions] ),
ALLSELECTED ( 'Raw Data'[Channel Title] ),
ALLEXCEPT ( 'Raw Data','Raw Data'[month_year] )
),
0
)