Create a relationship using Specific or All values

Hi gomezc73 ,

Try the following formula:

Total Values =
VAR temp_table =
    FILTER (
        CROSSJOIN ( 'Balance sheet accounts', 'Balance Transactions' ),
        'Balance sheet accounts'[Account Sub] = 'Balance Transactions'[Sub]
            && 'Balance sheet accounts'[Account Type] = 'Balance Transactions'[Object]
            && 'Balance sheet accounts'[Cat3] = 'Balance Transactions'[BU Cat03]
            && ( 'Balance sheet accounts'[Cat6] = 'Balance Transactions'[BU Cat06]
            || 'Balance sheet accounts'[Cat6] = "*All" )
    )
RETURN
    SUMX ( temp_table, 'Balance Transactions'[Value] )

This is giving the correct result for the small sample you present however not sure if it will return correctly on your overall values since the details can make all the difference:

Also be aware that I have unpivot the transactions in order not to have a calculation for each column.

Check PBIX file attach.

That command CrossJoin works fine. I really appreciate your help.. thank you very much!!