Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

SUMX and FILTER

Hi, Let me simplify my question. Besides my Date table I have three other tables. Fact table, containing: account-id transaction-date debit-currency-key credit-currency-key dim_debit_cu...
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

    Anonymous , Try using

    Number of Trx with Different Currencies =
    SUMX(
    FILTER(
    Fact,
    RELATED(dim_debit_currency[debit-currency-code]) <> RELATED(dim_credit_currency[credit-currency-code])
    ),
    Fact[transaction-count]
    )

     

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
1 year ago

Anonymous , Try using

Number of Trx with Different Currencies =
SUMX(
FILTER(
Fact,
RELATED(dim_debit_currency[debit-currency-code]) <> RELATED(dim_credit_currency[credit-currency-code])
),
Fact[transaction-count]
)