Forum Discussion
Filter Formula by Date
I created a Table and displayed to top 15 by impressions
Since using grand % total would give me the % based off those top 15 only, I created a calculated column
% = 'Raw Data'[Impressions]/Sum('Raw Data'[Impressions])
When I add it to the column, it is not rolling those %'s by the Page Filter (which would be months) so would the answer be adding a filter to the column formula?
I have tried messing around with it but can't get the right combo any suggestions?
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
)
2 Replies
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
)
