cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User I
Super User I

Re: calculated column changes values in report

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.

View solution in original post

2 REPLIES 2
Highlighted
Super User I
Super User I

Re: calculated column changes values in report

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.

View solution in original post

Highlighted
Helper I
Helper I

Re: calculated column changes values in report

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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors