ISFILTERED not working

I want to display the values based on filter on column. I am using ISFILTERED but is it not working as expected. Can someone help on this issue? Suppose we have a table as shown below and we have co...