Filter Formula by Date

[Anonymous]

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?

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[Anonymous · Accepted solution]

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

)