So basicaly, measure no 1, for calculate the target value according to filter context of my report which usually by Region and Branch, and measure no 2 to calculate the Target value in months / quarter if it the report is break down by months / quarter whereby the Target given is yearly only.
So I have this "beautifull" visual like this :
What I still have no clue, what if I want to add another table into that visual, like the Employee from Resources table which is a master / dimension table contain the list of employee. There is no employee in Target table, so there is no direct relation to that table. What it has actually, in the Resources table, there is Branch info.
I want to use that Branch info so that it only display resources in the same branch that display on that "above" visual.
Without any relationship at the moment, also there is no filter whatsoever in measures of the Target table, what I got now is all employee listed out.
Any advice on how to solve it, much appreciated. Btw how to attach a file in this message? I'd like to attach my PBIX for better sampling.
I am not sure what desired result would you want, could you please share desired output screenshots for further analysis? You can also upload sample pbix to OneDrive and post the link here. Do mask sensitive data before uploading. You can find OneDrive here.
Anyway, the transition from Yearly value to Monthly is not the issue, it is already correct as they are.
What I want to achieve or the main issue is later when you see my PBIX, I have this table visual which contain :
- Target Value
Then I have a Resource table, it is a list of Worker, which it has the info of their branch. (Resource branch)
So, I want to add this Resources to the 1st table visualization, but it needs to match the branch code of the 1st visual, so it only display the Resources belong to the branch in the respected row.
The matching is something like this :
So table visualization no 1, for row no 1, because it says the branch code is 109, it will only listed Resources (from table no 2) with Resource branch 109, which is Julia Funderburk. The target value may remain as it is.
For row no 2, Branch is 110, the Resource only 2, Jack Robinson and Julia Anderson.
For row no 3, Branch is 112, the Resource are 2 also, with colored green.
and so on.
What I have now, all worker in Resources are listed in my Table visual.
Actually I cannot delete the relationship between Timesheet since it is my FACT Table. However, I did make the relationship again between Location and Resources but make it inactive (to avoid ambiguity)