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 " C...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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