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...
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

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