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
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