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

Thank you for you'r response but it's not working..

 

I've the same result

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello MaxPail22 
If I'm right you want to show 25 in measure column. Isn't it?

  • MaxPail22's avatar
    MaxPail22
    Frequent Visitor
    5 years ago

    Yes I want to repeat 25 for all row in my tab.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello MaxPail22 
      It can be done with ALL. Can you please share the formula for [Qte facturées] or some sample data after removing sensitive data?

      • MaxPail22's avatar
        MaxPail22
        Frequent Visitor
        5 years ago

        Anonymous 

         

        The formula for [Qte facturées] : 

        Qte facturées = SUM('Ligne de facture'[Quantite])