Forum Discussion
Filtering table based on Measure result
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.
2 Replies
Anonymous , refer my HR blog and attached file on a similar topic
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.
