Forum Discussion
Error while grouping
Hi Anonymous,
Based on my test, you could refer to below formula:
Filename2 = var a=SUMMARIZE('CreditOutputSummary','CreditOutputSummary'[SourcingFileName],"t",SUM(CreditOutputSummary[Amount])) return SUMX(a,[t])Result:
You could download the pbix file to have a view.
Regards,
Daniel He
Please share your pbix file so that I can help you on this
Hi affan,
Wont be able to share due to access issue, I can share a raw format.
| Filename | SourcingFileName | Date | Amount |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_ADJ_V1_3517_06291802415620182906044509.TXT | 6/30/2018 0:00 | -451461 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_ADJ_V1_3517_06291802415620182906044509.TXT | 6/30/2018 0:00 | -70358 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -5306.3 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -2074.11 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -1932.2 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -1318.86 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -1081.98 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -1076.36 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -696.01 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -663.3 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -659.43 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -581.78 |
| Filename: ABC 001 | TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT | 6/28/2018 0:00 | -556.68 |
Hi Anonymous
Can you also share the expected result! What you are trying to acheive.
Sure affan,
This is the expected result
Filename SourcingFileName Date Amount Filename: ABC 001 TW_TESTS_HJG_ABC001_H1_ADJ_V1_3517_06291802415620182906044509.TXT 6/30/2018 0:00 -521819 Filename: ABC 001 TW_TESTS_HJG_ABC001_H1_V1_3469_06281802530720182806042107.TXT 6/28/2018 0:00 -15947.01 Thanks
Anonymousfor this result you don't need any measure or calculated column.
See the below I have created from the data you shared.
You can download the PBIX file for your reference.
https://www.dropbox.com/s/stjui4thb296zc1/Error%20while%20grouping.pbix?dl=0
Please mark this post as an accepted solution if this helped you.
Regards,
Affan
Anonymous Please try this, by adding a "New Table"
FileAmountOut = SUMMARIZECOLUMNS(FileAmount[Filename],FileAmount[SourcingFileName],FileAmount[Date],"Amount",SUM(FileAmount[Amount]))
