calculated column changes values in report

[Lanko]

Hi all, 

I created that calculated column:

sum_1 = CALCULATE(SUM(fct_Orderdata[Total_order_price]);FILTER(fct_Orderdata;fct_Orderdata[Soldto_number] = EARLIER(fct_Orderdata[Soldto_number])))

It sums all prices up of one Soldto_number. 

When I want to use that sum_1 in a report, it changes its values for a report with only soldto_number and sum_1

I figured out, that when I create a report and add all columns of  fct_orderdata to it, I'll receive the same result in the report as I do receive in the table fct_orderdata. 

So my question is: How do I need to design sum_1 that allows me only using soldto_number as a reference in a report?

Many thanks

Lanko

[HotChilli · Accepted solution]

This is a slightly confusing question.

A calculated column doesn't change value.  You are seeing, I believe, an aggregation of the column in a table.

Show us your data and the desired outcome and i'm sure someone will help.

[Lanko]

Thanks @HotChilli  PowerBi just summarized automatically the values... as you said