Is there an option to use different filters on data when filtering with slicers?

[Niels_T]

Hello,

I have data of what the customer searches on the website I use the page view metric from Google Analytics to achieve this result, however, it is so much that I put a filter on it. 

An example. Here I put a filter of greater than 200, this gives me a good view: 

The thing is when I filter with a slicer on date I want the filter "greater than 200" to be automatically removed because otherwise I won't see my data.

Example: I look at a specific date and filter greater than 200 is still active so no data:

Is this possible?

[Anonymous · Accepted solution]

Hi @Niels_T ,

You can create a separate calendar table, and an option table.

Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

nValue = 
IF (
    ISFILTERED ( 'Table 2'[Date] ),
    CALCULATE (
        MAX ( 'Table'[Value] ),
        FILTER (
            'Table',
            MIN ( 'Table 2'[Date] ) <= [Date]
                && [Date] <= MAX ( 'Table 2'[Date] )
        )
    ),
    IF (
        ISFILTERED ( 'Table (2)'[Slicer] ),
        CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( 'Table', [Value] > 200 ) ),
        SUM ( 'Table'[Value] )
    )
)

When you don’t use the date slicer, only values greater than 200 are displayed. When you use the date slicer, the filter greater than 200 is ignored.

You can check more details from here.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Niels_T , This will sum of dates where count > 200

make sure you date do not have timestamp

sumx(filter(Summarize(Table,Table[date],"_1", count(Table[date]])),[_1]>200),[_1])

Date = [Datetime].date
or
Date = date(year([Datetime]),month([Datetime]),day([Datetime]))