Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SUM distinct rows returning error

I'm trying to create a total transaction amount from a table (SalesLines) of the individual sales lines.    I created a new table (Table) with the distinct transaction numbers and I tried to create...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

    Create a measure instead of column using the following DAX and check if you get expected result. If not, share sample data as other post.

    Measure  = CALCULATE (
    SUM (SalesLines[NetAmount] ),
    FILTER (
        SalesLines,
        CONTAINS (
           Table,
           Table[TrasactionNumber] , SalesLines[TransactionNumber]
        )
    )
)



    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

Create a measure instead of column using the following DAX and check if you get expected result. If not, share sample data as other post.

Measure  = CALCULATE (
    SUM (SalesLines[NetAmount] ),
    FILTER (
        SalesLines,
        CONTAINS (
           Table,
           Table[TrasactionNumber] , SalesLines[TransactionNumber]
        )
    )
)



Thanks,
Lydia Zhang