Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I created that calculated column:
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
Solved! Go to 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.
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.
Thanks @HotChilli PowerBi just summarized automatically the values... as you said