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 
You can try this.
Mesure =
CALCULATE( [Qte facturées],
FILTER(
ALL('Produits lancés'), '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?