Forum Discussion

MaxPail22's avatar
MaxPail22
Frequent Visitor
5 years ago
Solved

How repeat SUM for each ROW ?

Hi,   I want to repeat the SUM for this product for each row in this context :   .   How can I do that ?    I've tried to make a mesure like this :  Mesure = CALCULATE([Qte facturées],'...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hello MaxPail22 
    Can you check this out?
    Mesure =
    CALCULATE(
    [Qte facturées],
    ALL('Ligne de facture'),
    'Produits lancés'[Code produit] = "501067" )
    )

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello MaxPail22 
Can you check this out?
Mesure =
CALCULATE(
[Qte facturées],
ALL('Ligne de facture'),
'Produits lancés'[Code produit] = "501067" )
)

MaxPail22's avatar
MaxPail22
Frequent Visitor
5 years ago

I think it's the good way, I've modified the formula like this : 

Mesure =
var selected = SELECTEDVALUE('Produits lancés'[Code produit + libellé])
RETURN
CALCULATE(
[Qte facturées],
ALL('Ligne de facture'),
'Produits lancés'[Code produit + libellé] = selected)
 
But now it's repeat for all my fournisseur :