Need help with relationships

[vanhell54321]

Requirement 

Creating a report which shows Individual contribution vs Team in % . The team works on tickets. Need to implement RLS.Need to use slicers for Date(Year and month)

Duplicated the ticket table(removed the employee column) as the table was getting impacted when using RLS.

It may sound simple but facing some issues when an employee is selected from the slicer the total count of the team is also changing which should not happen. This might be happening because of the date table relationship.
Not sure how to avoid this .

Requesting for inputs.

Thanks!

[d_gosbell · Accepted solution]

---

@vanhell54321 wrote:

It may sound simple but facing some issues when an employee is selected from the slicer the total count of the team is also changing which should not happen. This might be happening because of the date table relationship.

---

It's hard to say without seeing the filtering settings for your relationships, but if your relationships on the date table are setup to do bi-directional filtering it could cause behaviour like this. What it would do would be to filter the second tickets table down to only dates that existed for a given employee in the first tickets table. Which is probably not what you want.

If this is the case the fix would be to turn off bi-directional filtering and just have single direction filtering from Date to the 2 Tickets tables. (a good practice is to set all relationships to single direction filters by default unless you specifically know you need a bi-directional filter and understand the consequences) 

[v-xuding-msft · Accepted solution]

Hi @vanhell54321 , 

By my test, you can create a irrelative table as a slicer to filter the table of Individual contribution. The following is my sample you can have a try.

Measure = 
var a = SELECTEDVALUE(EMPLOYEE[EMPLOYEE])
var b = CALCULATE(COUNT(Individual[Tickets]),ALL(Individual[employee]),FILTER(Individual,Individual[employee] = a))
return 
SWITCH(TRUE(),ISFILTERED(EMPLOYEE[EMPLOYEE]),b,SUM(Individual[Tickets]))

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[d_gosbell · Accepted solution]

---

@vanhell54321 wrote:

It may sound simple but facing some issues when an employee is selected from the slicer the total count of the team is also changing which should not happen. This might be happening because of the date table relationship.

---

It's hard to say without seeing the filtering settings for your relationships, but if your relationships on the date table are setup to do bi-directional filtering it could cause behaviour like this. What it would do would be to filter the second tickets table down to only dates that existed for a given employee in the first tickets table. Which is probably not what you want.

If this is the case the fix would be to turn off bi-directional filtering and just have single direction filtering from Date to the 2 Tickets tables. (a good practice is to set all relationships to single direction filters by default unless you specifically know you need a bi-directional filter and understand the consequences)