Media rapida multiplicacion

[lluis]

I'm new to PowerBI and now I have my first problem.
I have created an average that multiplies value by quantity but I do not want to perform the operation with the total values of the table.
The average is very simple.

Bajas Internas =
CALCULATE(SUM ('tabla1$Item'[Precio Coste medio ]) * SUM ('tabla2$Item Ledger Entry'[Quantity])* -1)

                    precio coste medio                     quantity                  Bajas internas

                              5                                            -1                               5

                              0.75                                       -100                           75

                               3                                           -100                           300

              ------------------------------------------------------------------------------

                  total     8.75                                      -201                           1758.75

I need the total to be the sum of internal losses and not the multiplication of the totals ...

I hope you can help me

[MFelix]

Hi @lluis ,

I'm assuming that you have some other column on your table that makes a identification of each line correct try to do the following measure:

Bajas Internas =
VAR Bajas_Internas =
    CALCULATE (
        SUM ( 'tabla1$Item'[Precio Coste medio ] )
            * SUM ( 'tabla2$Item Ledger Entry'[Quantity] ) * -1
    )
RETURN
    IF (
        HASONEFILTER ( 'tabla1$Item'[Column] );
        Bajas_Internas;
        SUMX ( ALLSELECTED ( 'tabla1$Item'[Column] ); Bajas_Internas )
    )

Replace the Column by the name of the column you are using to identify each line.

Regards,

MFelix

[lluis]

Thank you very much for answering

[lluis · Accepted solution]

You can solve the problem by creating a new calculated column, using:

 Bajas Internas = 'tabla1$Item Ledger Entry'[Quantity]*RELATED('tabla1$Item'[Precio Coste medio)

See you later