Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sum total rows that have the same expression

I have DocumentID, LineNo and Amount as columns. I want to sum all DocumentID's Amount that have a specific expression on LineNo. The result from the picture should be the sum of blue values, ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    Aha, then try this:

    Measure =
    VAR IDList =
    CALCULATETABLE(
        VALUES(TableName[DocumentID]),
        TableName[LineNo]="test1"
    )
    RETURN
    CALCULATE(
        SUM(TableName[Amount]),
        IDList
    )
     
    i tried and it worked like this:

     

    I used some simplified data like below:

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

It works! Thank you!

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

Only in the last chat, came I to understand your expection. The requirement clarification is soooo important.