Filtering table based on Measure result

[Anonymous]

Hello,

this is my first week working in Power Bi, and I am facing some basic issues you'd maybe help me with.

I have a table listing a series of activities, each with the start/end dates and the assigned resource.

I want to know for each week how many activities/resources are used. So I created the following measure which seems to work fine.

ResourceByDate = COUNTROWS(FILTER(Resources,Resources[Start]<=MAX('Calendar'[Date]) && Resources[Finish]>MIN('Calendar'[Date])))

Now the problem is that I would like that when I click on a particular week on the top table, I can see in the bottom table only the activities happening that particular week.

[amitchandak]

@Anonymous , refer my HR blog and attached file on a similar topic

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

[Anonymous]

Thank you @amitchandak , I tried with your file but I got a similar issue. 

In your file, if I select a date from the Trends view, the resources selected are the ones just hired in that date (hired employees).

What I am trying to do is to see the list of the "current Emplyees". For example if I select June 2015, I want to get 8 employees, whilst now I am gettin only the 2 that just started.

This is due to the fact that the active relationship is between Start Date and Date.