Filtering everything but one column in a table?

[Anonymous]

Hi, 

I have got a filtering issue here. I created a measure for finding when a keyword was first seen based on the date table and the calculate funciton: 

First Seen = CALCULATE(FIRSTDATE([Date]), ALL([Date]))

However, my first date column is limited by my calendar table. In other words, whenever I change the date, the first seen date changes as well. 

To give you an example, let's say that keywords appeared on 6th May for the first time. Therefore, with the maximum date range, the chart will correctly show: 

Nevertheless, when I change to let's say last 3 months, the data is filtered by the calendar filter: 

This is obviously wrong as the keywords have appeared earlier. Is there any way how to overcome this issue? Such as, unfilter one column in the table? 

[amitchandak]

@Anonymous , I doubt you need all selected

Try

First Seen = CALCULATE(FIRSTDATE([Date]), ALLSELECTED([Date]))

First Seen = CALCULATE(Min([Date]), ALLSELECTED([Date]))

[Anonymous]

@amitchandak the same issue as before,

I am actually trying to get rid off the filter created by calendar slicer for this specific column, not to apply it: 

This is the output I got using 'ALLSELECTED' function

[Anonymous · Accepted solution]

I solved it using this formula: 

First Seen = CALCULATE(MIN([Date]), ALL('Calendar'[Date]))

 And then applying filter for impressions >0