Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |