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

     

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

Hi Anonymous ,

 

My observation is that your fact table doesn't contain amount column but the accounting records should have matching debits and credits which should balance (add up) to zero, and currency should be the same for the given transactions. I am trying to understand which situation your particular requirement arises, as your accounting system will record the transaction in document currency (transaction currency) which will be converted automatically to your local currency.  I'd greatly appreciate it if you could let me know why your fact table doesn't have the amount field.  

 

Best regards,