topic Re: Total (sum) of a measure in DAX Commands and Tips

Total (sum) of a measure

Anonymous — Tue, 06 Sep 2022 13:11:26 GMT

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.

Re: Total (sum) of a measure

amitchandak — Tue, 06 Sep 2022 13:20:25 GMT

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])

Re: Total (sum) of a measure

tamerj1 — Tue, 06 Sep 2022 13:21:10 GMT

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)] ) ) )

Re: Total (sum) of a measure

Anonymous — Tue, 06 Sep 2022 13:25:53 GMT

As I see it seems working !! Thank you