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

calculate the SUM of a mesure

achrafkasmi — Fri, 03 Feb 2023 14:45:38 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

amitchandak — Sat, 04 Feb 2023 02:47:04 GMT

achrafkasmi , Try measure like

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

achrafkasmi — Mon, 06 Feb 2023 11:27:04 GMT

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,