calculate the SUM of a mesure ( urgent )

[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

[achrafkasmi]

hello, @v-zhangti , thanks for your answer ,

the measure " besoin en rpm " is not the same as " besoin PF ".

the need in finished product is in red " besoin PF " that is to say to produce it I need a calculation of the sum of the raw materials " besoin en rpm ".

I’ll show you the result that i want on excel : 

So if I can summarize, we’ll consider the MESURE "BESOIN PF" as a positive values i need to calculate the SUM for each ItemName.

thanks,

[v-zhangti]

Hi, @achrafkasmi 

You can try the following methods.
BESOIN PF is a measure.

Besoin on RPM = ABS('Table'[BESOIN PF])

Besoin Total = SELECTEDVALUE('Table'[StockMP])-[Besoin on RPM]

CodeBom 91000915 [Besoin on RPM] Sum is 515, not 396.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.