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

MaxPail22's avatar
MaxPail22
Frequent Visitor
5 years ago

Anonymous 

 

The formula for [Qte facturées] : 

Qte facturées = SUM('Ligne de facture'[Quantite])
 
 
MaxPail22's avatar
MaxPail22
Frequent Visitor
5 years ago

With fournisseur : 

 

In this case I want to repeat 25 for each row

Without fournisseur :

  • 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 :