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 ...
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")*-1
LeistFabrikLeistunfert = calculate(sumx(Fabrikleistung,Fabrikleistung[Value]),Fabrikleistung[Book]="521002")*-1
The result should be displayed in each row of the column because it refers to the order number.
Ashish_Mathur
Super User
Super UserJust cannot understand your requirement.
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.
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?