Forum Discussion
Sum over one criterion
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
8 Replies
Hi Anonymous
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
Hi,
Share the download link of the PBI file.
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.
LeistBestandsverFert = calculate(sumx(Fabrikleistung,Fabrikleistung[Value]),Fabrikleistung[Book]="522000")LeistBestandsverUnfert = calculate(sumx(Fabrikleistung,Fabrikleistung[Value]),Fabrikleistung[Book]="521000")LeistFabrikLeistFert = calculate(sumx(Fabrikleistung,Fabrikleistung[Value]),Fabrikleistung[Book]="522002")*-1LeistFabrikLeistunfert = calculate(sumx(Fabrikleistung,Fabrikleistung[Value]),Fabrikleistung[Book]="521002")*-1The result should be displayed in each row of the column because it refers to the order number.
