Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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
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 .
Cool dude,
First u could under stand the logic what u did .
based on your Summarize function it is correct result .
see the condtion u have applied in new column level then how it will work at table level ?
make sense.
if u want only Entry type =1
add filter in front of Summarize and apply filter where entry type = 1
example :
Filter ( Summarize(............), Entry_Type =1 )
it will help u, let me know if any help.
I have did that Baskar but at the end the summerize donot giving the correct value.
For Example-
if Doc.No Xxxxx having multiple Payment
10000 1st
2000 2nd
3000 3rd
the result should show the value =15000 gainst the Doc No Xxxxx
But its is not giving the correct it only shows the value i.e. 10000
Do one thing my friend share some sample data and what is ur expected result .
i will help u
Entry No_ | Cust_ Ledger Entry No_ | Entry Type | Posting Date | Document Type | Document No_ | Amount | Amount (LCY) |
10524 | 55305 | 1 | 4/27/2012 0:00 | 1 | BRV/DEC/09/01393 | -131367 | -131367 |
10533 | 55315 | 1 | 4/26/2012 0:00 | 1 | BRV/DEC/09/01395 | -490000 | -490000 |
10534 | 55317 | 1 | 4/26/2012 0:00 | 1 | BRV/DEC/09/01396 | -490000 | -490000 |
10535 | 55319 | 1 | 4/26/2012 0:00 | 1 | BRV/DEC/09/01397 | -6734 | -6734 |
10557 | 55759 | 1 | 4/30/2012 0:00 | 1 | BRV/DEC/09/01434 | -27575 | -27575 |
10561 | 55767 | 1 | 5/3/2012 0:00 | 1 | BRV/DEC/09/01435 | -186131 | -186131 |
10566 | 55775 | 1 | 5/5/2012 0:00 | 1 | BRV/DEC/09/01436 | -165450 | -165450 |
10567 | 55777 | 1 | 5/5/2012 0:00 | 1 | BRV/DEC/09/01437 | -151387 | -151387 |
10587 | 55899 | 1 | 5/8/2012 0:00 | 1 | BRV/DEC/09/01443 | -44550 | -44550 |
10588 | 55901 | 1 | 5/8/2012 0:00 | 1 | BRV/DEC/09/01444 | -5100 | -5100 |
10631 | 56515 | 1 | 5/21/2012 0:00 | 1 | BRV/DEC/09/01480 | -70000 | -70000 |
10641 | 56535 | 1 | 5/21/2012 0:00 | 1 | BRV/DEC/09/01481 | -1216744 | -1216744 |
10647 | 56586 | 1 | 5/14/2012 0:00 | 1 | BRV/DEC/09/01490 | -33437 | -33437 |
10648 | 56588 | 1 | 5/14/2012 0:00 | 1 | BRV/DEC/09/01491 | -30000 | -30000 |
10664 | 56653 | 1 | 5/23/2012 0:00 | 1 | BRV/DEC/09/01492 | -195082 | -195082 |
10675 | 56823 | 1 | 5/25/2012 0:00 | 1 | BRV/DEC/09/01499 | -5100 | -5100 |
10677 | 56828 | 1 | 5/25/2012 0:00 | 1 | BRV/DEC/09/01500 | -118570 | -118570 |
10680 | 56832 | 1 | 5/25/2012 0:00 | 1 | BRV/DEC/09/01501 | -39600 | -39600 |
10687 | 56846 | 1 | 5/28/2012 0:00 | 1 | BRV/DEC/09/01504 | -5300 | -5300 |
10712 | 56963 | 1 | 5/29/2012 0:00 | 1 | BRV/DEC/09/01511 | -498282 | -498282 |
10735 | 56997 | 1 | 5/29/2012 0:00 | 1 | BRV/DEC/09/01513 | -28630 | -28630 |
10746 | 57024 | 1 | 5/31/2012 0:00 | 1 | BRV/DEC/09/01515 | -82921 | -82921 |
10765 | 57184 | 1 | 6/2/2012 0:00 | 1 | BRV/DEC/09/01522 | -104530 | -104530 |
10770 | 57195 | 1 | 6/4/2012 0:00 | 1 | BRV/DEC/09/01524 | -83427 | -83427 |
10771 | 57197 | 1 | 6/4/2012 0:00 | 1 | BRV/DEC/09/01525 | -6741 | -6741 |
10774 | 57201 | 1 | 6/4/2012 0:00 | 1 | BRV/DEC/09/01526 | -195555 | -195555 |
10775 | 57203 | 1 | 6/4/2012 0:00 | 1 | BRV/DEC/09/01527 | -81793 | -81793 |
10845 | 57780 | 1 | 6/13/2012 0:00 | 1 | BRV/DEC/09/01552 | -131533 | -131533 |
10849 | 57784 | 1 | 6/15/2012 0:00 | 1 | BRV/DEC/09/01553 | -150000 | -150000 |
10863 | 57950 | 1 | 6/19/2012 0:00 | 1 | BRV/DEC/09/01569 | -222984 | -222984 |
10870 | 57965 | 1 | 6/22/2012 0:00 | 1 | BRV/DEC/09/01571 | -1293493 | -1293493 |
10873 | 57972 | 1 | 6/22/2012 0:00 | 1 | BRV/DEC/09/01574 | -290466 | -290466 |
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
60 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |