Forum Discussion
Issue in the filter
I am tryinmg to summerize the amount in my data on the basis of entry type=1 but when i am applying the filter i am facing this issue as i shown,
If their is any mistake in my code please make me correct so i can move on.
Thanks
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
11 Replies
Cool machi .
1. Don't use summarize function it will create performance issue. my suggestion is go with ADDColumn.
or if u want summarize u can go with that, i will help u .
Solution :
Filter( Summarize ( here ur stuffs whatever u have already ) , entry_type=1)
This will work if not let me know machi i will help u .
I hope u r from Tamil Nadu.
I am creating a new table for that i need a DAX formula.
And if i am not wrong then addcoloumn will fail in that i just want to know that why this is giving me opposite result.
And i am from Delhi dude i lived in tamil 2 year back .
Regards,
Satish Kumar
Can u please share ur formula , it is not clear in that image .
