Issue in the filter

Hi Satish_Kumar，

>> if Doc.No Xxxxx having multiple Payment, the result should show the value =15000 gainst the Doc No Xxxxx.

10000 1st
2000   2nd
3000  3rd
 
I create the sample data and create a new table using the formula.

Table 2 = SUMMARIZE(Table2,Table2[Type],"Amount",SUM(Table2[Doc]))

As shown in the snapshot, it will return the desired result about sum of “Doc” group by “Type”.

Based on my understanding, do you want to calculate the sum of amount for “Entry Type”=1 group by Document No_, Posting Date, Entry Type, right? If it is, I try to reproduce it using your given sample data.

Create a new table using the formula below, and get expected result shown the screenshot.

Table = SUMMARIZE(Table1,Table1[Document No_],Table1[Posting Date],Table1[Entry Type],"Invc Amount",CALCULATE(SUM(Table1[Amount]),Table1[Entry Type]=1))

 
If you have any other issue, please share more details.

Best Regards,
Angelia