Forum Discussion
Calculated column gets summed up
Hi,
In my report, calculate columns gets summed up and the aggregate value is shown in all rows.
How can I get individual original values? (Screenshot added)
Suggestions pls!
Thanks,
Sab
4 Replies
Anonymous , what are you trying to do here.
In the case of calculated column sum(Table[Value]) is a grand total. In case of the measure that is sum by group by , if no group by it is grand total
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thanks for the reply.
I am getting aggregate values in rows(for the 3 calc columns) which I don't need.
"Counter_Parts_Sales, Fitted_Parts_Sales & Trade_Parts_Sales" are calculated columns and they show summed up values in all rows. I need the individual values on those fields. Rest of the columns are good.
Please find attahced the screenshot of table.
Following are the queries for those 3 calc columns.
X_Trade_Parts_Sales = if ([JOB_TYPE] = "", If ([TRADE_TYPE] = "T" || [TRADE_TYPE] = "I", if([TYPE] = "C" || [type] = "I", 'InTrans'[SALE_VAL])))X_Fitted_Parts_Sales = If ('InTrans'[JOB_TYPE]="R" || 'InTrans'[JOB_TYPE]="I"||'InTrans'[JOB_TYPE]="S" || 'InTrans'[JOB_TYPE]="F" || 'InTrans'[JOB_TYPE]="E" || 'InTrans'[JOB_TYPE]="P" || 'InTrans'[JOB_TYPE]="W", If ([TRADE_TYPE] = "C" || [TRADE_TYPE] = "R" || [TRADE_TYPE] = "T", if([TYPE] = "C" || [type] = "I", 'InTrans'[SALE_VAL])))
X_Counter_Parts_Sales = if ([JOB_TYPE] = "", If ([TRADE_TYPE] = "C" || [TRADE_TYPE] = "R", if([TYPE] = "C" || [type] = "I", 'InTrans'[SALE_VAL])))
Suggestions Pls!
Thanks,
Sab
Is there any solution to my question? Please find my reply to your question at the bottom.
Hi Anonymous ,
There may be many reasons for the above error. Can you provide test data (delete sensitive information), otherwise I may not be able to do further accurate tests to determine the cause of the error.
Looking forward to your reply.Best Regards,
Henry
