The SUM function only accepts a column reference as an argument.

[AmiraBedh]

SUM((PFIINVESTISSEMENT -
(ENVMTINITIAL-VSTD_ENVMTDISPO))*DPPMTPART)
When I try to apply it in DAX :

KPI1 :=SUM(
DPPMTPART *
([PROP_MtDemandeFin] -(PFIINVESTISSEMENT -
(ENVMTINITIAL-VSTD_ENVMTDISPO) )
)

I have this error :

The SUM function only accepts a column reference as an argument.

[VahidDM]

@AmiraBedh 

Yes, SUM just Adds all the numbers in a column.

See this link:

https://docs.microsoft.com/en-us/dax/sum-function-dax

You can use SUMX.

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

Appreciate your Kudos!!

[amirabedhiafi · Accepted solution]

You need SUMX iterator function.KPI1 :=SUM(

SUMX('Table', [DPPMTPART] *
   ([PROP_MtDemandeFin] -([PFIINVESTISSEMENT] - ([ENVMTINITIAL]-[VSTD_ENVMTDISPO]))))