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],'Produits lancés'[Code produit] = "501067") but is not working...
 
Thank you per advance for your help.
 
Regards,

 

 

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

10 Replies

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello MaxPail22 
    It'll be good if you share the sample data in table format or pbix file after removing the sensitive data.