Forum Discussion
USERALATIONSHIP and slicer selection
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 :
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
3 Replies
- amitchandakSuper User
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"))
- AnonymousNot applicable
- AnonymousNot applicable
Thank you, I've changed my model and now everything is working fine .