Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 :

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 

 

 

3 Replies

  • 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"))

  • Anonymous's avatar
    Anonymous
    Not applicable

     Hi amitchandak

     

    Thank you for trying, unfortunately no change 😞

  • Anonymous's avatar
    Anonymous
    Not applicable

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