Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filtering everything but one column in a table?

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? 

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    I solved it using this formula: 

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

     And then applying filter for impressions >0

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , I doubt you need all selected

    Try

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

     

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        Anonymous
        Not applicable
        5 years ago

        I solved it using this formula: 

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

         And then applying filter for impressions >0