Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

calculated column changes values in report

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

 

Need Help
  • HotChilli's avatar
    HotChilli
    6 years ago

    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.

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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