Ambigous path relationship

Question

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

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

&nbsp;

cnenfrnl · Answer

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

ronaldbalza2023 · Answer

Hi&nbsp;CNENFRNL&nbsp;, thanks for taking the time on this. Actually, I did this before you reply on my query but unfortunately it does the same thing.&nbsp;