Forum Discussion
Error while grouping
Hi Team, Need your support, I am getting an error "Query (3, 5) Calculation error in measure 'CreditOutputSummary'[1cols]: Function 'GROUPBY' scalar expressions have to be Aggregation functions ...
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
Anonymous Please try this, by adding a "New Table"
FileAmountOut = SUMMARIZECOLUMNS(FileAmount[Filename],FileAmount[SourcingFileName],FileAmount[Date],"Amount",SUM(FileAmount[Amount]))
