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.
Hello all,
I have a table with various information.
I have an order. Different material numbers are assigned to this order. In my measure, the correct number is now displayed based on the smallest criterion, i.e. the material. Now I want to have a measure that shows the sum of my current measure in the rows. The new measure should aggregate my old one based on the order.
The 6,626.52 is the sum of my orders and I would like to display this in another column.
Can anyone help me?
Thanks in advance
Thank you for your answers.
Unfortunately, I cannot publish any data from my organisation.
Here is an excerpt from my model. It is only about one table. With all the information in the table.
The formulas are just aggregations over a column of my data table:
LeistBestandsverFert = calculate(sumx(Fabrikleistung,Fabrikleistung[Betrag]),Fabrikleistung[Hauptbuch]="522000")
This is what my data table looks like:
Year | Period | Belegart | Book | Material | Order | Value | BME |
2022 | 02 | WE | 522002 | 02011601110 | 10525686 | -797,000 | ST |
2022 | 01 | WA | 521000 | 0201000000102 | 10525686 | 31,210 | ST |
2022 | 01 | WA | 521000 | 0201000111204 | 10525686 | 114,920 | ST |
2022 | 01 | WA | 521000 | 0201000111304 | 10525686 | 25,920 | ST |
2022 | 01 | WA | 521000 | 0902000654602 | 10525686 | 7,070 | ST |
2022 | 01 | WA | 521000 | 0902000654802 | 10525686 | 7,140 | ST |
2022 | 01 | WA | 521000 | 0902000650502 | 10525686 | 149,770 | ST |
2022 | 01 | WA | 521000 | 0902000650602 | 10525686 | 145,420 | ST |
As a result, I need a new column that does the following for all order values:
=((Value for Book "522002") - (Value for Book "521002"))
As a result, I have a value of 315.55 in the new column for the order.
@Ashish_Mathur @PhilipTreacy Can you help?
Hi,
Do you want the result as 315.55 in each row of the Result column? Also, in your measure you have referred to columns which i do not see in your data at all.
My measure is simply an addition or subtraction of the value depending on which book is being addressed.
The result should be displayed in each row of the column because it refers to the order number.
Just cannot understand your requirement.
With the filter Allselected, I now get the result in every row as desired. However, this only works if I also set an order in the filter. Do you have a solution how I can work around this?
I do not want to have the result of the factor output at the bottom of the totals column. It should be in a new column in each row.
Hi,
Share the download link of the PBI file.
Hi @Daniel28-DH
I don't have access to your file and hence your measure, but you could use this to sum the value per order
Measure = CALCULATE(SUM('DataTable'[Value]), FILTER(ALL('DataTable'), 'DataTable'[Order] = SELECTEDVALUE('DataTable'[Order])))
Giving this
Regards
Phil
Proud to be a Super User!
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 |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |