topic Re: How repeat SUM for each ROW ? in DAX Commands and Tips

How repeat SUM for each ROW ?

MaxPail22 — Wed, 23 Jun 2021 09:04:31 GMT

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,

Re: How repeat SUM for each ROW ?

Anonymous — Wed, 23 Jun 2021 10:50:08 GMT

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

Re: How repeat SUM for each ROW ?

MaxPail22 — Wed, 23 Jun 2021 11:08:07 GMT

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

I've the same result

Re: How repeat SUM for each ROW ?

Anonymous — Wed, 23 Jun 2021 11:21:53 GMT

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

Re: How repeat SUM for each ROW ?

MaxPail22 — Wed, 23 Jun 2021 11:23:39 GMT

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

Re: How repeat SUM for each ROW ?

Anonymous — Wed, 23 Jun 2021 11:30:50 GMT

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?

Re: How repeat SUM for each ROW ?

MaxPail22 — Wed, 23 Jun 2021 11:35:33 GMT

Anonymous

The formula for [Qte facturées] :

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

Re: How repeat SUM for each ROW ?

MaxPail22 — Wed, 23 Jun 2021 11:39:04 GMT

With fournisseur :

In this case I want to repeat 25 for each row

Without fournisseur :

Re: How repeat SUM for each ROW ?

Anonymous — Wed, 23 Jun 2021 11:43:37 GMT

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

Re: How repeat SUM for each ROW ?

MaxPail22 — Wed, 23 Jun 2021 12:49:04 GMT

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 :

Re: How repeat SUM for each ROW ?

Anonymous — Wed, 23 Jun 2021 13:25:48 GMT

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