topic Re: calculate the SUM of a mesure ( urgent ) in DAX Commands and Tips

calculate the SUM of a mesure ( urgent )

achrafkasmi — Fri, 10 Feb 2023 08:19:37 GMT

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

Re: calculate the SUM of a mesure ( urgent )

v-zhangti — Mon, 13 Feb 2023 03:02:58 GMT

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.

Re: calculate the SUM of a mesure ( urgent )

achrafkasmi — Mon, 13 Feb 2023 10:37:52 GMT

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,