Calculate the SUM of the difference and multiplication of some columns

[amirabedhiafi]

I have the following formula to calculate a KPI :

SUM((PFIINVESTISSEMENT -
(ENVMTINITIAL-VSTD_ENVMTDISPO))*DPPMTPART)

When I try to apply it in DAX :

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

I get the following error :

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

[nvprasad · Accepted solution]

Hi ,

You need to sumx to get the result.

could you please check with below dax?

KPI1 :=SUMX(tablename,
DPPMTPART *
([PROP_MtDemandeFin] -(PFIINVESTISSEMENT -
(ENVMTINITIAL-VSTD_ENVMTDISPO) )
)

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad