cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lanko
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
HotChilli
Super User II
Super User II

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
HotChilli
Super User II
Super User II

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

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.