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:
No, this measure will sum only rows with "test1". This will sum only green rows, I need to sum blue rows.
FreemanZ
Super User
Super Usertry to create a measure with the code below:
Test1Amount =
CALCULATE(
SUM(TableName[Amount]),
TableName[DocumentID] in {"SCM234", "SCM235", "SCM236"}
)
This is just a sample. I have millions of documents and I don't know which one of them has "test1" on LineNo.
- FreemanZ
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:
It works! Thank you!