Resolved -- Power Query Question

Using formula:FILTER(Table1[[Claim Number]:[Amount paid]],Table1[Service]="Test Type 2")

Using PQ, M code:

Please Login or Register  to view this content.

Thank you for your response but I may not have articulated myself well and I apologize. What you provided is very close.

• If you look at the Total Claim Amount Tab, you can see that the Total Claim Amount column is the sum of all line items for the claim.
• I want the same date in the Total Claim Amount field (the sum of all lines) but I want to include only those claims that have Test 2.
• The solution provided returns the claim but only with the amount of the line item for Test 2 for the Total Claim Amount.

I have uploaded the file with notes that I hope are clear

This is it. Thank you!

For Claim Number, formula=FILTER(Table1[Claim Number],Table1[Service]="Test Type 2")
For Amount paid, formula=SUMIF(Table1[Claim Number],FILTER(Table1[Claim Number],Table1[Service]="Test Type 2"),Table1[Amount paid])