Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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:

YearPeriodBelegartBookMaterialOrderValueBME
202202WE5220020201160111010525686-797,000ST
202201WA52100002010000001021052568631,210ST
202201WA521000020100011120410525686114,920ST
202201WA52100002010001113041052568625,920ST
202201WA5210000902000654602105256867,070ST
202201WA5210000902000654802105256867,140ST
202201WA521000090200065050210525686149,770ST
202201WA521000090200065060210525686145,420ST


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?


  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        Just cannot understand your requirement.