Total (sum) of a measure

[Anonymous]

Hello,

I need help to change the total of these measures.

To explain I already done a measure that multiply a price by a quantity,

FY19-20 x Qté composants (UQB) =

SUM('Fichier Acheteur'[FY19-20]) * SUM('Mapping'[Qté composants (UQB)])

the probleme is that the total multiply the final price by the quantity too, I just a need a sum of the column in the total.

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

FY19-20 x Qté composants (UQB) =
SUMX (
    CROSSJOIN ( VALUES ( TableName[P/N] ), VALUES ( TableName[Designation] ) ),
    CALCULATE (
        SUM ( 'Fichier Acheteur'[FY19-20] ) * SUM ( 'Mapping'[Qté composants (UQB)] )
    )
)

[Anonymous]

As I see it seems working !! Thank you

[amitchandak]

@Anonymous , This needs to be done at some common level

example

sumx(summarize(CommonDim, CommonDim[P/N], CommonDim[Designation] , "_1", calculate(SUM('Fichier Acheteur'[FY19-20]) * SUM('Mapping'[Qté composants (UQB)])) ) , [_1])