calculate the SUM of a mesure

[achrafkasmi]

Hello,

i have a table named "V_QTSDAMA" and I have a column named "ItemName"  with a repeating products with its own stock.

I need to calculate the sum of " BESOIN PF " for each product. ( to not to have the products repeating themselves)

PS : note that the column "BESOIN PF" it's calculated as a Mesure.

- i work on a directquery Mode.

For exemple this is result that I want  , i made it on excel : 

Thanks, 

ACHRAF KASMI

[amitchandak]

@achrafkasmi , Try measure like

Sumx(Summarize(Table, Table[Besoin Pf], Table[Stock MP], Table[Besoin en Rpm]), [Stock MP] -[Besoin en Rpm])

[achrafkasmi]

hank you for your answer, 

the formulate doesn’t work, she didn’t return the sum, she just returned I think the minimum and not the sum.

but with this formulate i'm able to shave the ItemName.

thanks,