USERALATIONSHIP and slicer selection

[Anonymous]

Hello 

I would appreciate any help on the following:

My model has an active relationship between "Cost Center #" and "Employee Cost Center" and an inactive one between "Cost Center #" and " Costed Cost Center" fields

I have a Cost center slicer that I was hoping will be working in both scenarios : when I need to see the total cost for a cost center it might contain costs coded by employees from various other cost centers. 

So far for that scenario I am only getting the number coded by employees of selected in the slicer cost center :

Total Cost Costed CC FTE = CALCULATE([Total Cost], USERELATIONSHIP(Tech_Projects[Costed Cost Center],'Tech Div Cost Centers'[Cost Center #]),FILTER(Tech_Projects,Tech_Projects[DR a/c Description]="Payroll Cost Allocation"))

when in relaity it should be the following : 

Total Cost Costed CC FTE = CALCULATE([Total Cost], Tech_Projects,Tech_Projects[Costed Cost Center]="2212",FILTER(Tech_Projects,Tech_Projects[DR a/c Description]="Payroll Cost Allocation"))

The number is smaller, as there were some transfers out of cost center, but 192K is what I expect.

It seems as if userelationship isn't responding when cost center on the filter is selected.

Thank you 

[Anonymous]

Thank you, I've changed my model and now everything is working fine .

[Anonymous]

 Hi @amitchandak

Thank you for trying, unfortunately no change 😞

[amitchandak]

@Anonymous , Try with this small change

CALCULATE(CALCULATE([Total Cost], USERELATIONSHIP(Tech_Projects[Costed Cost Center],'Tech Div Cost Centers'[Cost Center #])),FILTER(Tech_Projects,Tech_Projects[DR a/c Description]="Payroll Cost Allocation"))