calculate the SUM of a mesure in Directquery

[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 all ,

can someone help ?

thanks,

[johnt75]

You can try

Total of products =
VAR ProductsWithValues =
    ADDCOLUMNS ( VALUES ( 'V_QTSDAMA'[ItemName] ), "@value", [BESOIN PF] )
VAR Result =
    SUMX ( ProductsWithValues, [@value] )
RETURN
    Result

[achrafkasmi]

thank 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,