Forum Discussion

Gazi_Sohan's avatar
Gazi_Sohan
Icon for Helper I rankHelper I
2 years ago

DAX measure using calculate

Hi guys, I am trying to calculate Net Income between 2 accounts (account numbers between 400000 and 957090), however I want the account number to come from the columns instead of hard coded. I tried ...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Gazi_Sohan,

Measure formula does not support to directly use other table columns across multiple tables.

I'l like to suggest you use aggregate functions to handle table field value to aggregate them and return get single value as condition in these expressions:

Net_income =
CALCULATE (
    [Actual Amounts],
    FILTER (
        ALLSELECTED ( COADetails_New ),
        COADetails_New[AccountID] >= MIN ( 'Balance Sheet Table'[Start Account] )
            && COADetails_New[AccountID] <= MAX ( 'Balance Sheet Table'[End Account] )
    )
)

Regards,

Xiaoxin sheng