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 over CurrentGroup(). The expression of each Aggregation has to be either a constant or directly reference the columns in CurrentGroup()."
While typing below code
Filename = GROUPBY(CreditOutputSummary,CreditOutputSummary[DataSourcingFileName],"Files",SUM(CreditOutputSummary[CreditAmount]))
Thanks for your support
Regards
Abhijit Mishra
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
13 Replies
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.
