Forum Discussion
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, ...
Aha, then try this:
Measure =VAR IDList =CALCULATETABLE(VALUES(TableName[DocumentID]),TableName[LineNo]="test1")RETURNCALCULATE(SUM(TableName[Amount]),IDList)i tried and it worked like this:I used some simplified data like below:
This is just a sample. I have millions of documents and I don't know which one of them has "test1" on LineNo.
FreemanZ
Super User
Super UserAha, 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:
It works! Thank you!
- FreemanZ
Only in the last chat, came I to understand your expection. The requirement clarification is soooo important.