Forum Discussion
Ambigous path relationship
Hi everyone, could someone help me out on my data model please. Error on my dax shows there were ambigous paths between my tables. Thanks in advance 😊
Total Bills Cost of Sales =
CALCULATE (
SUM ( 'Bill Line Items'[Line.Amount] ),
FILTER (
'Accounts',
Accounts[AccountType] = "Expense"
|| Accounts[AccountType] = "Other Expense"
|| Accounts[AccountType] = "Cost of Goods Sold"
),
USERELATIONSHIP ( 'Bill Line Items'[Line.ItemBasedExpenseLineDetail.ItemRef.value], Items[Id] ),
USERELATIONSHIP ( Accounts[Id], Items[ExpenseAccountRef.value] )
)
2 Replies
Deactivate another circuit
Total Bills Cost of Sales = CALCULATE ( SUM ( 'Bill Line Items'[Line.Amount] ), FILTER ( 'Accounts', Accounts[AccountType] = "Expense" || Accounts[AccountType] = "Other Expense" || Accounts[AccountType] = "Cost of Goods Sold" ), USERELATIONSHIP ( 'Bill Line Items'[Line.ItemBasedExpenseLineDetail.ItemRef.value], Items[Id] ), USERELATIONSHIP ( Accounts[Id], Items[ExpenseAccountRef.value] ), CROSSFILTER ( ACCOUNTS[col], 'Bill Line Items'[col], NONE ) )Hi CNENFRNL , thanks for taking the time on this. Actually, I did this before you reply on my query but unfortunately it does the same thing.
