Calculated column gets summed up

[Anonymous]

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

[v-henryk-mstf]

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

[amitchandak]

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

[Anonymous]

@amitchandak 

Is there any solution to my question? Please find my reply to your question at the bottom.

[Anonymous]

@amitchandak 

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