How repeat SUM for each ROW ?

[MaxPail22]

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]

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

[Anonymous]

Hello @MaxPail22 
You can try this.
Mesure =
CALCULATE( [Qte facturées],
FILTER(
ALL('Produits lancés'), 'Produits lancés'[Code produit] = "501067" )
)

[MaxPail22]

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

I've the same result

[Anonymous]

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

[MaxPail22]

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

[Anonymous]

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]

@Anonymous 

The formula for [Qte facturées] : 

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

[MaxPail22]

With fournisseur : 

In this case I want to repeat 25 for each row

Without fournisseur :

[Anonymous · Accepted solution]

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

[MaxPail22]

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 :