KPI indicator

[Amardeep100115]

Hi

Please go through the below sample file in which i have 

If there is new addition of produst id in same/last month then it should be "New" and if not then "Existing" 

I have the results in attached file but now i wish to be have a sumerized table or DAX function which shows me results like if there is no value selected then it should display currant month data for "NEW"or "EXISTING" product data and month wise data as i select month.

In my existing file i am using below DAX for having results for currant month 

Sample Data 

Please help me 

[v-chuncz-msft · Accepted solution]

@Amardeep100115 

It seems that you may try ISFILTERED inside IF function.